Re: Mail Merge query results with Office 2002

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.






.