Thread: [Solved] 2 names on address label
View Single Post
 
Old 02-08-2015, 10:50 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

It is really only practical for a mailmerge to add a second name from a different record to the same label. Adding a second name to a label is only practical if the second name occurs in a field for the same record.

Thus, if your Excel data are laid out like:
Mr John Smith|Ms Sarah Jones|123 Maple St|Anytown|NJ|10365
where the | character indicates a different cell, merging both names to the same label is quite feasible, but not if the data are laid out like:
Mr John Smith|123 Maple St|Anytown|NJ|10365
Ms Sarah Jones|123 Maple St|Anytown|NJ|10365
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote