If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query from access does not show up in list for mail merge
Trying to perform mail merge in word. When I select my database source
(access), the query I want to use is not listed as an option to choose from. |
#2
|
|||
|
|||
Query from access does not show up in list for mail merge
From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. Then when you attach the datasource, you will be presented with a dialog box in which you can select the way in which the connection to the data source is made. Selecting the DDE option may overcome your problem. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "RB" wrote in message ... Trying to perform mail merge in word. When I select my database source (access), the query I want to use is not listed as an option to choose from. |
#3
|
|||
|
|||
Query from access does not show up in list for mail merge
The query will not show up if it is hidden. You must unhide it in Access
before you set it up as the datasource in Word. Once set up, you can then hide it again and it will work. -- Ted |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
mail merge and access query | DaveAS | Mailmerge | 6 | January 6th, 2005 06:33 PM |
is Access 2003 any better than XP? | Gorb | General Discussion | 4 | November 11th, 2004 09:44 PM |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |