Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Beach Lover Beach Lover is offline
external usenet poster
 
Posts: 64
Default Using Office 2007 & cannot do a mail merge using Access Query

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?
  #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 Using Office 2007 & cannot do a mail merge using Access Query

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.

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

"Beach Lover" wrote in message
...
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?



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
Mail merge on an access query... Warrio Mailmerge 2 September 16th 06 12:49 AM
Mail Merge From Access Query hspgapsemc Mailmerge 1 May 21st 06 07:07 AM
Mail merge with Access DB does not see a query SarahB Mailmerge 8 November 29th 05 08:18 PM
Mail Merge from Access Query KelMon Mailmerge 1 March 1st 05 02:52 AM
mail merge and access query DaveAS Mailmerge 6 January 6th 05 07:33 PM


All times are GMT +1. The time now is 11:23 AM.

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"