Mail Merge from Multiple Datasources

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jws - 20 Mar 2008 18:03 GMT

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 to this Message

magicdds - 21 Mar 2008 05:34 GMT

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

> 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 to this Message

Doug Robbins - Word MVP - 22 Mar 2008 22:54 GMT

Wrong answer for this question at least.

Signature

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

> You need to query the two sources. To avoid the repeating lines, correct
> the
[quoted text clipped - 14 lines]
>> 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 to this Message

Doug Robbins - Word MVP - 22 Mar 2008 12:29 GMT

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

Signature

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

>I have related data in two seperate but releated Access tables but it
>appears
[quoted text clipped - 4 lines]
> 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 to this Message

Rate this thread: