Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-31-2019, 08:21 AM
doucecool67 doucecool67 is offline Excel/Word Mail Merge - Same Address...different names/Rows Windows 7 32bit Excel/Word Mail Merge - Same Address...different names/Rows Office 2013
Novice
Excel/Word Mail Merge - Same Address...different names/Rows
 
Join Date: May 2019
Posts: 1
doucecool67 is on a distinguished road
Default 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!
Reply With Quote
  #2  
Old 05-31-2019, 03:37 PM
macropod's Avatar
macropod macropod is offline Excel/Word Mail Merge - Same Address...different names/Rows Windows 7 64bit Excel/Word Mail Merge - Same Address...different names/Rows Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel/Word Mail Merge - Same Address...different names/Rows MAIL Merge - Site Address / Invoice address mgsjarvis Mail Merge 3 09-25-2018 02:43 PM
Excel/Word Mail Merge - Same Address...different names/Rows Mail Merge Multiple Rows -word(from Spain) luisaranda Mail Merge 6 03-06-2016 09:32 AM
Excel/Word Mail Merge - Same Address...different names/Rows 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
Excel/Word Mail Merge - Same Address...different names/Rows Mail merge with names in content richard82 Mail Merge 1 07-07-2011 11:28 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft