Access 2003 and mail merge with query

B

beans

After converting to Access 2003, i can no longer use a query in mail merge.
The wizard for mail merge only gives access to tables and not queries. Mail
merge via queries worked nicely in Access 2000.
 
S

Sheila D

Hi

Are you sure your query isn't there? Word 2003 does not have a separate tab
for queries but does lists all tables and queries that can be used for mail
merge. I had a problem with parameter queries but select queries are fine.

Sheila
 
B

beans

thanks Sheila D.

When starting mail merge from word 2003 to Access i only get a fraction of
the many queries i have in my application - maybe i need some update for
Access 2003, tho i am running SP1, which to my knowledge is the latest.

Søren

"Sheila D" skrev:
 
D

Douglas J Steele

Might the missing queries be action queries (INSERT INTO, UPDATE or DELETE)?
 
V

Van T. Dinh

Generally, you only get non-parametrised Select Queries (A2002).

If you need to use a parametrised Select Query as the DataSource for your
MailMerge, you need to use a work-around to get the Parametrised Query to
appear in Word.

Action Queries (INSERT / UPDATE / etc ...) do not return rows and therefore
cannot be used as DataSource for MailMerge.
 
M

muneer

Sheila D said:
Hi

Are you sure your query isn't there? Word 2003 does not have a separate
tab
for queries but does lists all tables and queries that can be used for
mail
merge. I had a problem with parameter queries but select queries are fine.

Sheila
Click to expand...
 
O

o.f.martin

here's the problem I'm having. I design the query, it works fine in Access. I
select the "Merge It with Word" option, and get 0 records in Word.

I have gotten around it by exporting the query to Excel then using that
spreadsheet as my Word data source. It works, but it's a pain, especially
knowing that I could perform this function in previous versions.

Any thoughts would be welcome.
 
Top