Mailmerge with varying output

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BTC - 19 Jul 2006 15:25 GMT

Can a mailmerge be set up to produce a document like this:

<Name>
<Address>
<City>, <State> <Zip>

<item1>
<item2>
<item3>

The number of items varies for each name.

My source data is setup like this

Jones, address, city, st, zip item 1
Jones, address, city, st, zip item 2
Jones, address, city, st, zip item 3
Smith, address, city, st, zip item 1
Smith, adddress, city, st, zip item 2
Doe, address, city, st, zip item 1
Thomas, address, city, st, zip item 1
Johnson, address, city, st, zip item 1

I would like each letter I create to list the items associated with each
name.

Thanks for any help

Bruce

Reply to this Message

Peter Jamieson - 19 Jul 2006 19:28 GMT

Word isn't designed to do this - if possible, use a Report generator
designed to do it (e.g. the one in Access).

Or try e.g.

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

and/or

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

Peter Jamieson

> Can a mailmerge be set up to produce a document like this:
>
[quoted text clipped - 25 lines]
>
> Bruce

Reply to this Message

Rate this thread: