Mail Merge query results with Office 2002

[Jerry M. Gartner]

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.

 

[Vincent Johns]

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 <[email protected]>
Please feel free to quote anything I say here.

 

[Jerry M. Gartner]

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.

 

[Jerry M. Gartner]

Oh, yeah, one vital tidbit: The query contains a user input parameter.
Sorry for leaving that out!

 

[Jerry M. Gartner]

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.

 

[Vincent Johns]

I'm afraid I don't know why Tables are showing up and not Queries, but
it appears that you've worked your way around that problem. Thanks for
sharing with us how you did that.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

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.

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.

[...]

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.