#1
|
|||
|
|||
Excel/Word Mail Merge - Same Address...different names/Rows
Not sure if more of an excel question or a Word Question but here is my issue. We use an EHR where the contact report that is exported has every contact separated into their own row in excel...
for example: mom and dad, living in the same house, have separate entries in the form and are on their own rows within the excel report. I would like to combine mom and dad on one address block for an envelope so they do not receive two invitations to the same event... Prefix First Name Last Name Address City State Zip Mr Tom Brady 6 Patriots Road Foxboro MA 02035 Mrs. Gisele Bundchen 6 Patriots Road Foxboro MA 02035 Desired Result: Mr. Tom Brady and Mrs. Gisele Bundchen 6 Patriots Road Foxboro, MA 02035 Thanks! |
#2
|
||||
|
||||
Cross-posted (and answered) at: https://www.mrexcel.com/forum/genera...ent-names.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
MAIL Merge - Site Address / Invoice address | mgsjarvis | Mail Merge | 3 | 09-25-2018 02:43 PM |
Mail Merge Multiple Rows -word(from Spain) | luisaranda | Mail Merge | 6 | 03-06-2016 09:32 AM |
trouble setting excel to import correctly into mail merge. Not using typical address fields | ragoo | Mail Merge | 1 | 10-28-2014 03:42 PM |
mail merge with duplicate names but different dollar amounts | bh24524 | Mail Merge | 27 | 03-24-2014 01:15 PM |
Mail merge with names in content | richard82 | Mail Merge | 1 | 07-07-2011 11:28 PM |