How do I Mail Merge from an Access Query?

[ken1975]

I am trying to set up a mail merge in Word to pull from an Access Query.
When I select the Access database as the data source, it only gives me the
tables within that database to choose from. In Word 2000, there was a tables
tab and a queries tab but in 2003, only the tables are shown. Is there
another process to follow to have it show the queries within the Access
database?

 

[Doug Robbins]

From the Tools menu in Word, select Options and on the General tab, check
the box against the "Confirm conversions at open" item and the when you
attach the data source, you will be asked which method of connection to use.
I believe selecting the DDE option will give you access to 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]

That worked!!!! Thank you, Thank you, Thank you!!!! It has taken 3 days
and 2 MIS people from my company and no one could figure this out!!!!
Thanks again!!

 

[geordymac]

I was having the same problem until I found this post. thank you very much.
Why does Microsoft make things like this so difficult??

 

[Doug Robbins]

To give us something to do<g>

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

 

[geordymac]

I suppose

To give us something to do<g>

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