Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Supress the blank space from a blank data field?
My wife is using an Excel data source to create a Word mail merge.
She needs to supress the blank space that is created from a blank middle initial field. All the anwers I've found here deal with blank LINES not spaces. How can she do what she wants? Thanks, -- John |
#2
|
|||
|
|||
You need a conditional field. Assuming fieldnames firstame lastname and
initial {Mergefield Firstname} {IF {Mergefield Initial} "" "{Mergefield Initial} "}{Mergefield Lastname} Note the space before the closing quote. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org John wrote: My wife is using an Excel data source to create a Word mail merge. She needs to supress the blank space that is created from a blank middle initial field. All the anwers I've found here deal with blank LINES not spaces. How can she do what she wants? Thanks, |
#3
|
|||
|
|||
Graham,
Many thanks from both of us. -- John "Graham Mayor" wrote: You need a conditional field. Assuming fieldnames firstame lastname and initial {Mergefield Firstname} {IF {Mergefield Initial} "" "{Mergefield Initial} "}{Mergefield Lastname} Note the space before the closing quote. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org John wrote: My wife is using an Excel data source to create a Word mail merge. She needs to supress the blank space that is created from a blank middle initial field. All the anwers I've found here deal with blank LINES not spaces. How can she do what she wants? Thanks, |
#4
|
|||
|
|||
HELP! I have the same problem. I'm using Office 2000 and am creating
envelopes in Word using an Excel spreadsheet as my data source. When I insert my merge fields, there are no brackets {} as shown below. I have tried copying exactly what is on the sample below, but all of the characters (carrots, quotes, brackets, etc) print on the evelope. Each of my merge fields is bracketed by double "baby" carrots (I don't have that key on my keyboard so I can't show you what I mean). I have tried to modify the example below according to the format I have, but the word IF prints on the envelope or I still get that space if there is no middle initial. I tried researching "conditional field" in the help section of the application, but no luck. I don't know what else to try! Thanks! "Graham Mayor" wrote: You need a conditional field. Assuming fieldnames firstame lastname and initial {Mergefield Firstname} {IF {Mergefield Initial} "" "{Mergefield Initial} "}{Mergefield Lastname} Note the space before the closing quote. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org John wrote: My wife is using an Excel data source to create a Word mail merge. She needs to supress the blank space that is created from a blank middle initial field. All the anwers I've found here deal with blank LINES not spaces. How can she do what she wants? Thanks, |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting field does not format all field data | Microsoft Word Help | |||
Enter data in 1 text form field & have multiple locations fill | Microsoft Word Help | |||
How do I add a space in a line if a merge field is blank? | Mailmerge | |||
How do I remove or supress blank data in fields in mail merge e.g. | Mailmerge | |||
Word Field Codes in Excel data file | Mailmerge |