Hello,

Im trying to do a mail merge from excel into word and I can get a page per person, however the excel contains the same person multiple times. For Example the excel contains "The recipient" and then the "Account Number" columns, some people have multiple accounts. So I would like all of those accounts (different rows in excel) to be included in a single letter to the person.

So something like the below;



Dear XX,

Your accounts details are:

Account1
Account2
Account3

Regards,
Me

The account numbers are all in the same column, and the number of accounts per person varies, so I cant convert them into individual columns without alot of manual work (over 300 recipients)

Does anyone know if this is possible and if so how?

Thanks.

1. The first thing I would do is to make a back-up copy of my SS so I could experiment
   
2. Next I would clean-up my SS by next going into my Excel SS, then Data, then Remove Duplicates until I would have unique row per whatever I was trying to merge, or whatever
   

Hi Kieron,

You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/sho...ngs-(2000-2010)
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it.

For a recent, worked example, see the attachment to post #13 at: https://www.msofficeforums.com/mail-...nt-dollar.html

Alternatively, you may want to try the Many to One utility on the MergeTools Add-in that you can download from the following page of Doug Robbins' Windows Live SkyDrive: https://skydrive.live.com/?cid=5aedc...615E886B%21111

There is no need to reformat your Excel wb, which probably wouldn't be very helpful anyway.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]