Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Alan Ingersoll Alan Ingersoll is offline
external usenet poster
 
Posts: 1
Default Word 2003 Mailmerge w/Access 2003 Select Queries

Word 2003 Mailmerge doesn't list all Access 2003 Queries as potential data
sources. Most are listed in the Tools setup for data sources, but not all.
The queries are basic Select Queries.
Why would this happen?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Word 2003 Mailmerge w/Access 2003 Select Queries

Are there any parameters in the Queries that don't appear. That is, if you
open the query in Access, does a dialog box pop up asking you for a
response?

In Word, from the Tools menu, 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 data source to the mail merge main document, try selecting
DDE as the method of connection when a dialog box opens that asks how the
connection should be made.

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

"Alan Ingersoll" Alan wrote in message
...
Word 2003 Mailmerge doesn't list all Access 2003 Queries as potential data
sources. Most are listed in the Tools setup for data sources, but not all.
The queries are basic Select Queries.
Why would this happen?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MailMerge from Access to Word 2003 [email protected] Mailmerge 10 May 30th 07 04:04 AM
Inability to see queries in complicated access files: 2003 access& bird lover Mailmerge 1 December 29th 06 09:02 PM
Where is the list of Access queries for MailMerge? Margaret Bartley New Users 4 December 16th 05 12:38 AM
Mailmerge 2003 Word documents with Access yes/no values BrendaV Mailmerge 1 October 14th 05 04:21 PM
Mailmerge using Word and Access 2003 Chester1 Mailmerge 1 October 5th 05 12:47 PM


All times are GMT +1. The time now is 12:01 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"