View Single Post
  #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 How to use two tables as data sources in Word 2003

You cannot. What you must do is create a Select Query in access that
combines the necessary fields from the tables and then use that Query as the
data source.

You may also need to use the information in fellow MVP Macropod's "Word
97-2007 Catalogue/Directory Mailmerge
Tutorial" at:

http://www.wopr.com/index.php?showtopic=731107

or

http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip

Do read the tutorial before trying to use the mailmerge document included
with it as you must get the mail merge main document set up exactly as
required.

But if that is the case, you should also consider using an Access Report.

--
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, originally posted via msnews.microsoft.com

"stud91" wrote in message
news
How do we select two different tables [from one Access 2003 file] as data
sources in Mail Merge.