Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jws jws is offline
external usenet poster
 
Posts: 1
Default Mail Merge from Multiple Datasources

I have related data in two seperate but releated Access tables but it appears
that I can only slect one source. If I query the two sources I get the data
from the one table repeating for each line of the other table. These tables
have a one to many relationship and I want header data from one table and
multiple rose from the other on the merged page.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
magicdds magicdds is offline
external usenet poster
 
Posts: 15
Default Mail Merge from Multiple Datasources

You need to query the two sources. To avoid the repeating lines, correct the
join properties in the query. Double click on the join line and the property
box will appear. Click on the appropriate radio button so that the extra
lines in the query don't appear.

Hope this helps.
Mark

"jws" wrote:

I have related data in two seperate but releated Access tables but it appears
that I can only slect one source. If I query the two sources I get the data
from the one table repeating for each line of the other table. These tables
have a one to many relationship and I want header data from one table and
multiple rose from the other on the merged page.

  #3   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 Mail Merge from Multiple Datasources

Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the
ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at
http://homepage.swissonline.ch/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default...b;en-us;211303

http://cornell.veplan.net/article.aspx?&a=3815

However, If I were you, I would use an Access report. It's far simpler.
..
--
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

"jws" wrote in message
news
I have related data in two seperate but releated Access tables but it
appears
that I can only slect one source. If I query the two sources I get the
data
from the one table repeating for each line of the other table. These
tables
have a one to many relationship and I want header data from one table and
multiple rose from the other on the merged page.



  #4   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 Mail Merge from Multiple Datasources

Wrong answer for this question at least.

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

"magicdds" wrote in message
...
You need to query the two sources. To avoid the repeating lines, correct
the
join properties in the query. Double click on the join line and the
property
box will appear. Click on the appropriate radio button so that the extra
lines in the query don't appear.

Hope this helps.
Mark

"jws" wrote:

I have related data in two seperate but releated Access tables but it
appears
that I can only slect one source. If I query the two sources I get the
data
from the one table repeating for each line of the other table. These
tables
have a one to many relationship and I want header data from one table and
multiple rose from the other on the merged page.



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
Merging from multiple datasources into 1 document Minnie Mailmerge 3 December 31st 07 02:45 PM
Mail-Merge: Can we have master detail relationship or multiple entities in word Mail-Merge? gmax2006 Microsoft Word Help 1 March 28th 07 06:28 PM
Multiple entries in mail merge JM Attero Mailmerge 2 January 4th 07 05:46 PM
mail merge to multiple files instead of 1 Patricia Mailmerge 1 March 10th 06 06:06 AM
Win 2k: Multiple Datasources, one document Chris Mailmerge 2 March 23rd 05 12:35 AM


All times are GMT +1. The time now is 10:55 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"