Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / January 2004

Tip: Looking for answers? Try searching our database.

Mail Merge Recipients in Access Query Problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rich - 05 Jan 2004 21:51 GMT
I have a MS Word template that uses mail merge directed
to an Access Database query.  When I select the Mail
Merge Recipients button, I see a list of all the fields
and records in the query.  I had set this up in MS Office
XP Professional using the mail merge wizard.  I have
another computer on the same network that has MS Office
2000 Professional.  Instead of the mail merge wizard it
has Mail Merge under the Tools menu, but despite being
able the select the same query, I cannot get Mail Merge
Recipients to show the fields and records of the query.  
Is there a fix for this?
Peter Jamieson - 06 Jan 2004 09:24 GMT
Word 2000 does not have the Mail Merge Recipients dialog, which was
introduced in Word XP/2002. Another significant difference from Word XP is
that Word 2000 does not have any facility to let you select that individual
records should be included in/excluded from the merge.

The nearest equivalent is to click the "Edit Data SOurce" button on the
mailmerge toolbar. If you have connected to the data using the default
method (DDE), then Access will be running and Word will request Access to
open a query results window and - I hope - switch the focus to that window.
However, if you connect using ODBC, then Access cannot be assumed to be
running and Word will prompt you to open the query using MS Query. Then,
a. if you respond "Yes", Word should initiate MS Query if it has been
installed, and display the query columns and rows. In some cases you may
even be able to edit the data in the data source (Records|Allow Editing I
think) and return the updates to Word (see the appropriate option on the
file menu). But IMO it is wise to keep your dealings with MS Query simple
and to a minimum.
b. if you respond "No", you get into completely different territory (Word
offers to break the link with the database, which is shorthand for "I'll
extract the data from the database, put it in a file, and make that file the
data source for your merge).

--
Peter Jamieson - Word MVP
Word MVP web site http://www.mvps.org/word

> I have a MS Word template that uses mail merge directed
> to an Access Database query.  When I select the Mail
[quoted text clipped - 7 lines]
> Recipients to show the fields and records of the query.
> Is there a fix for this?
 
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.