Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-24-2011, 01:33 AM
dmwesq dmwesq is offline Custom label size for merge Mac OS X Custom label size for merge Office for Mac 2011
Novice
Custom label size for merge
 
Join Date: Apr 2011
Posts: 7
dmwesq is on a distinguished road
Default

If I delete the space then the entries that do have a middle initial will now be missing a space between the first name and MI, so that won't do any good.



The "fax" field was accidentally pasted as the cell field, but I understand the same will apply to the other fields assuming I can get this to work at all.
Reply With Quote
  #2  
Old 04-24-2011, 02:00 AM
macropod's Avatar
macropod macropod is offline Custom label size for merge Windows 7 32bit Custom label size for merge Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

Quote:
Originally Posted by dmwesq View Post
If I delete the space then the entries that do have a middle initial will now be missing a space between the first name and MI, so that won't do any good.
The \b and \f switches tell Word what to insert before/following the field if it isn't empty. So, if the MI field has anything in it, a space will be inserted!
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-24-2011, 03:35 AM
dmwesq dmwesq is offline Custom label size for merge Mac OS X Custom label size for merge Office for Mac 2011
Novice
Custom label size for merge
 
Join Date: Apr 2011
Posts: 7
dmwesq is on a distinguished road
Default

I think we are missing something in our dialog. Here is an example

John A. Smith
Bob Jones

Obviously my merge must have a field for first name, middle initial and last name. John A. Smith will work fine, unless I follow your example and after toggling the field to add the switch I delete the space in the merge fields, which will result in either JohnA. Smith or John A.Smith, neither of which is good.

If I don't delete the space then I end up with Smith appearing fine but will get Bob Jones, and in some cases I am even getting an extra space so it will read Bob Jones. Since this all needs to go to print I can't have multiple extra spaces. Maybe this is just something that is not possible to do?
Reply With Quote
Reply

Tags
columns, labels, merge



Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom label size for merge Label merge sulasno Mail Merge 2 03-16-2011 01:55 AM
Custom label size for merge Saving custom page size comptech Word 2 10-05-2010 06:01 AM
Custom caption label annoyance zac Word 1 08-29-2010 09:56 AM
unable to save custom label OldBlueEyes Word 0 05-07-2010 11:30 PM
Trying to merge label data from file ClayShannon Mail Merge 0 09-16-2009 10:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:53 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