Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 02-08-2015, 10:50 PM
macropod's Avatar
macropod macropod is offline 2 names on address label Windows 7 64bit 2 names on address label Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,512
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
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
2 names on address label How do I print only 1 address label? scotty875 Word 1 07-15-2014 08:51 AM
2 names on address label How to start a label mail merge at a specific label? DHKaplan Mail Merge 2 04-17-2014 07:33 PM
Userform label bordercolor not controllable if click label skarden Word VBA 1 09-29-2013 07:27 PM
How to enter names in Resource Pool/names pstein Project 1 03-26-2012 07:37 AM
HELP! Outlook 2003 Address Books - multiple account address lists ukmonkeynuts Outlook 0 06-01-2011 06:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:56 PM.


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