Mail Merge from Multiple Datasources

[jws]

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.

 

[magicdds]

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

 

[Doug Robbins - Word MVP]

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/cindymeister/mergfaq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;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

 

[Doug Robbins - Word MVP]

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