MailMerge Repeating Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lydia - 02 Mar 2006 17:30 GMT

I am trying to do a mail merge using the results of an Access query.
My input looks like this (abbreviated):
1 smith title1
1 smith title2
1 smith title3
2 jones title4
I expect 2 letters, one to Smith with the 3 titles listed. The second to
Jones with one title listed. What I'm getting is 4 letters.

Is this possible?

Signature

Lydia

Reply to this Message

Doug Robbins - Word MVP - 03 Mar 2006 05:11 GMT

It's really easier to do with a report in Access.

Word does not really have the ability to do a multiple items per condition
merge:

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

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 am trying to do a mail merge using the results of an Access query.
> My input looks like this (abbreviated):
[quoted text clipped - 6 lines]
>
> Is this possible?

Reply to this Message