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 / November 2007

Tip: Looking for answers? Try searching our database.

Using Office 2007 & cannot do a mail merge using Access Query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Beach Lover - 06 Nov 2007 16:08 GMT
Recently upgraded to Office 2007.  I am trying to do a mail merge in Word
with the information coming from an Access query.  How do I do this?
Doug Robbins - Word MVP - 06 Nov 2007 19:40 GMT
Because I did not like the way that Access handled the screen real estate, I
went back to 2003 on this machine, but I am sure that somewhere in Access,
there will be the facility to initiate a Mail Merge with Word as there is
under the Tools menu in 2003.  Using that will allow you to avoid the
connection to the data source properties that you can experience in Word if
the connection method is not suitable.

In Word 2007, to be given the option of the way in which the connection to
the data source is made, click on the Pizza Button and then in the bottom
border click on Word Options and then go to the Advanced item and scroll
down to the General section and check the box for "Confirm file format
conversion at open".

Then when you go to attach the data source to the Mail Merge main document,
you will be given a choice of the method by which the connection should be
made.

Signature

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

> Recently upgraded to Office 2007.  I am trying to do a mail merge in Word
> with the information coming from an Access query.  How do I do this?

Rate this thread:






 
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.