How do I Mail Merge from an Access Query?

[ken1975]

I am trying to Merge from an Access Query to a Word Document to create
address labels. When I choose the Access database as my data source, it only
lists the tables in the database, not the queries. Is there a different
process for linking to queries?

 

[Doug Robbins]

Why not use the Report Label Wizard in Access? It can do the whole thing.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[ken1975]

I originally set this up with Office 2000 and I already have several merges
set up this way and I am trying to add one. Unfortunatly we upgraded to
Office 2003 and Access queries no longer are an option for a data source.
The people that use the existing merges are familiar with how they work and I
would like to be able to add more in when needed. Any suggestions??

 

[monterey63]

Anybody know the answer? I am having the same problem. Ken, did you figure it
out?

 

[Doug Robbins]

If you too are talking about labels, I would say "Why don't you just use
Access?"

If however, it's another type of merge that requires the main document be in
Word, then in Word, select Options from the Tools menu and then go to the
General tab and check the box against "Confirm conversions at open" Then
when you attach the data source to the main document, you will be given a
number of options for the method of connection, one of which should allow
you to access the queries.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[ken1975]

I accidently posted this twice and on the other posting is the answer I got
that worked. You need to open Word, go to Tools menu, then choose options.
Under the General tab, check the box for "Confirm Conversion at Open". Once
the box is checked, hit OK and then attempt the merge to the Access Database.
When you choose the Access database as your data source, a box will come up
asking you to confirm the conversion. Choose Microsoft Access DDE connection
(the second choice I believe) and hit OK. The box will close and a new one
will open with both tables and queries from that access database to choose
from just like in Office 2000. It worked perfectly for me. Good Luck!!