#1
|
|||
|
|||
Mail Merge from Excel
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. |
#2
|
|||
|
|||
|
#3
|
||||
|
||||
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] |
Tags |
excel 2003, mail, mail merge |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Import field from Excel to Powerpoint | xgravity23 | Office | 8 | 11-22-2012 02:08 PM |
Mail merge will not format date field generated by Excel IF statement | borntorun75 | Mail Merge | 3 | 12-16-2011 06:28 AM |
Word mail merge from a protected Excel worksheet | Platform | Mail Merge | 10 | 09-28-2011 05:12 AM |
Excel 2007 to Word 2007 Labels mail merge not working | rec | Mail Merge | 0 | 07-31-2010 10:45 AM |
Help with switches: Word mail merge with Excel | ks_ | Mail Merge | 0 | 12-09-2009 05:09 PM |