 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / February 2005How do I Mail Merge from an Access Query?
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? 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.  SignaturePlease 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 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 [quoted text clipped - 3 lines] > another process to follow to have it show the queries within the Access > database? 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!! > 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 [quoted text clipped - 8 lines] > > another process to follow to have it show the queries within the Access > > database? I was having the same problem until I found this post. thank you very much. Why does Microsoft make things like this so difficult?? > 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!!!! [quoted text clipped - 12 lines] > > > another process to follow to have it show the queries within the Access > > > database? To give us something to do<g> SignaturePlease 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 was having the same problem until I found this post. thank you very >much. [quoted text clipped - 24 lines] >> > > Access >> > > database? I suppose > To give us something to do<g> > [quoted text clipped - 26 lines] > >> > > Access > >> > > database?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.