Re: Mail Merge query results with Office 2002

Here's what I did:

I changed the select queries to a make table queries (user input
parameter still pops up where applicable) and then added command buttons to
the ui.

--

Regards,

Jerry M. Gartner

"Jerry M. Gartner" <user@xxxxxxxxxxxx> wrote in message
news:%23IeNMDoPGHA.720@xxxxxxxxxxxxxxxxxxxxxxx
Oh, yeah, one vital tidbit: The query contains a user input parameter.
Sorry for leaving that out! :)

--

Regards,

Jerry M. Gartner

"Jerry M. Gartner" <user@xxxxxxxxxxxx> wrote in message
news:OajOcznPGHA.3272@xxxxxxxxxxxxxxxxxxxxxxx
I'm not having any issues getting the mail merge to work with tables.
The queries that are in the database aren't showing up. Only the tables
are. I may end up doing a make table query - since only tables are there.
I'm not sure why the queries aren't available but they aren't.

--

Regards,

Jerry M. Gartner

"Vincent Johns" <vjohns@xxxxxxxxxxxxxxxxxx> wrote in message
news:elPNf.62333$PL5.34@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I'm not sure what you mean by "not available". If you open MS Word with
a blank document, turn on Mail Merge, and use the Create button to
create (e.g.) a new form-letter document, your next step is click on the
Get Data button in the "Data Source" section of the form, and then
choose "Open Data Source". It's not totally automatic; you have to
specifically select the file containing the data. In your case, I
imagine it'd be an Access database file, but the default file type is a
Word document. Change it (in the "Files of Type" list box) to "MS Access
Databases". Then choose your database file.

Your next choice is to select the (one) Table or Query containing the
records you want. You also need to insert into your document the MS
Word fields that invoke whatever fields from your Query you want to
include (via, for example, the "Insert Merge Field" button).

You need to limit yourself to just one Query, so if what you want to
include exists in more than one, I suggest writing a new Query in Access
to combine them, and to filter and sort the results as you'd like.
Access gives you plenty of freedom to specify filtering & sorting
options.

-- Vincent Johns <vjohns@xxxxxxxxxxxxxxxxxx>
Please feel free to quote anything I say here.

Jerry M. Gartner wrote:
Greetings:

When using Office 2003, from access, after executing a query, I can
got to Tools> Office Links> Mail Merge Word Document (SIC) and the
query data is available for merging. When doing the same thing with
Office 2002 (Office XP ?), this method just opens a word document with
the mail merge dialog open. The query data is not available and I
don't see adequate filtering abilities to get the information that I
want for the mail merge. Please advise as to how one may make query
data available for mail merge with Office 2002 (Office XP). Thanks in
advance.








.

Loading