Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / April 2008

Tip: Looking for answers? Try searching our database.

Word / Access Mail merge problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Andy Roberts - 12 Apr 2008 13:09 GMT
I cant seem to see the queries I need when I mail merge to access from Word.
I can only see one query?, even though several exist in my access database.

I can see all the tables fine.  I am using Word 2007 and Access 2003.

Andy
guzarva16 - 12 Apr 2008 14:52 GMT
NetworkTrade - 12 Apr 2008 17:35 GMT
I copied this from a MS support page and saved in a Word doc but forgot to
save the url.  I fixed the same problem for me:

Word- merge Query not found
SYMPTOMS
When you try to use a Microsoft Access query as the data source in a Word
mail merge operation, some of the queries in the Access database may be
unavailable as data sources in the Mail Merge Wizard.
Back to the top
WORKAROUND
To work around this problem, confirm that Word uses Dynamic Data Exchange
(DDE) when you attach the Access database to the mail merge document. To do
this, follow these steps:
1.    Open a new blank document.
2.    On the Tools menu, click Options, and then click the General tab.
3.    Click to select the Confirm conversion at Open check box, and then click
OK.
4.    On the Tools menu, point to Letters and Mailings, and then click Mail
Merge Wizard.
5.    Under Select document type, click the type that you want, and then click
Next: Starting document.
6.    Under Select starting document, click the document that you want to use,
and then click Next: Select recipients.
7.    Under Select recipients, click Use an existing list, and then click
Browse under Use an existing list.
8.    Locate and open the folder that contains the Access database that you
want to use as your data source, click the database, and then click Open.
9.    In the Confirm Data Source dialog box, click MS Access Databases via DDE
(*.mdb, *.mde), and then click OK.
10.    In the Microsoft Access dialog box, click the Queries tab, click the
query that you want to use, and then click OK.
NOTE: All the queries in the Access database are available.

Signature

NTC

> I cant seem to see the queries I need when I mail merge to access from Word.
> I can only see one query?, even though several exist in my access database.
>
> I can see all the tables fine.  I am using Word 2007 and Access 2003.
>
> Andy
 
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.