Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
stud91 stud91 is offline
external usenet poster
 
Posts: 1
Default How to use two tables as data sources in Word 2003

How do we select two different tables [from one Access 2003 file] as data
sources in Mail Merge.
  #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.


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
Word 2007 merge with 2 different data sources Forrest Mailmerge 1 November 26th 08 04:27 AM
Merging Word doc with 3 data sources JEverhart Mailmerge 8 August 21st 08 10:29 PM
Is It Possible to Merge MS Word Document with Two Online Data Sources?? The Moose Mailmerge 2 August 23rd 06 01:19 PM
Word 2003 won't keep data sources saved on network Schmidt DECU Mailmerge 2 November 5th 05 04:10 PM
multiple data sources and data form Chico Mailmerge 1 October 5th 05 04:56 AM


All times are GMT +1. The time now is 02:57 PM.

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

About Us

"It's about Microsoft Word"