Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to avoid extra spaces in 1st line of mailing address
I am using Excel spreadsheet data to merge into a Microsoft Word mailing
label template. The first line of the label draws from this info on Excel: MrMrs, 1st name, and, 2nd name, last name. When the merge occurs, sometimes there is an extra space before the 1st name and then sometimes extra space between names. How do I avoid these extra spaces? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to avoid extra spaces in 1st line of mailing address
It appears that you have some name fields without data so you are simply
merging the space between the fields. You need to conditionally merge the fields eg { Mergefield MrMrs }{If {Mergefield "1st Name"} "" " {Mergefield "1st Name"}"}{If {Mergefield "2nd Name"} "" " {Mergefield "2nd Name"}"} { Mergefield "Last Name" } The whole string goes on one line - wrapped naturally if too long to fit. Use CTRL+F9 for the brackets {} and ensure the fieldnames are spelled correctly. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org alh wrote: I am using Excel spreadsheet data to merge into a Microsoft Word mailing label template. The first line of the label draws from this info on Excel: MrMrs, 1st name, and, 2nd name, last name. When the merge occurs, sometimes there is an extra space before the 1st name and then sometimes extra space between names. How do I avoid these extra spaces? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extra Line Inserted following title and name line in Address Block | Mailmerge | |||
stop putting extra line spaces in email | Microsoft Word Help | |||
Deleting extra line spaces | Microsoft Word Help | |||
How do I get the address in the mailing wizard to line up? | New Users | |||
Mysterious line and extra spaces in footer! | Microsoft Word Help |