Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Cannot use queries from MS-Access
When I try to "Select a different list" in the Mail merge wizard, and
then locate the MS-Access database I would like to use, I only see the TABLES in this database, not the QUERIES. Could someone please tell how to be able to use Queries as basis for a mail merge in MS-Word? (I'm using Access 2002 and Word 2002) Mogens |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Cannot use queries from MS-Access
From the Tools menu in Word, select Options and then go to the General tab
and check the box for "Confirm conversions at open" Then, when you attach the data source to the mail merge main document, you will be presented with a dialog box that asks for the way in which the connection should be made. Use the DDE option. -- 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 "mogens" wrote in message ... When I try to "Select a different list" in the Mail merge wizard, and then locate the MS-Access database I would like to use, I only see the TABLES in this database, not the QUERIES. Could someone please tell how to be able to use Queries as basis for a mail merge in MS-Word? (I'm using Access 2002 and Word 2002) Mogens |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Cannot use queries from MS-Access
Doug Robbins - Word MVP wrote:
From the Tools menu in Word, select Options and then go to the General tab and check the box for "Confirm conversions at open" Then, when you attach the data source to the mail merge main document, you will be presented with a dialog box that asks for the way in which the connection should be made. Use the DDE option. Thanks a million! This really was one of those that I would never have found out myself. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to use Access queries as data source for a mail merge doc | Mailmerge | |||
DatasourceMulti-table queries are not visible as datasource for a | Mailmerge | |||
How do I access Word Help file without having to insert a CD ever. | Microsoft Word Help | |||
How to use access query computed fields in Word mailmerge | Mailmerge | |||
Word mail merge with Access | Mailmerge |