How do I Mail Merge from an Access Query?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ken1975 - 21 Oct 2004 00:57 GMT

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?

Reply to this Message

Doug Robbins - 21 Oct 2004 01:23 GMT

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

Signature

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

>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?

Reply to this Message

ken1975 - 21 Oct 2004 18:47 GMT

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??

> Why not use the Report Label Wizard in Access? It can do the whole thing.
>
[quoted text clipped - 3 lines]
> > lists the tables in the database, not the queries. Is there a different
> > process for linking to queries?

Reply to this Message

monterey63 - 27 Oct 2004 22:25 GMT

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

> 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
[quoted text clipped - 9 lines]
> > > lists the tables in the database, not the queries. Is there a different
> > > process for linking to queries?

Reply to this Message

Doug Robbins - 27 Oct 2004 23:24 GMT

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.

Signature

> Anybody know the answer? I am having the same problem. Ken, did you figure
> it
[quoted text clipped - 18 lines]
>> > > different
>> > > process for linking to queries?

Reply to this Message

ken1975 - 27 Oct 2004 23:29 GMT

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!!

> Anybody know the answer? I am having the same problem. Ken, did you figure it
> out?
[quoted text clipped - 12 lines]
> > > > lists the tables in the database, not the queries. Is there a different
> > > > process for linking to queries?

Reply to this Message