|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 1st, 2004, 03:03 PM
|
|||
|
|||
Removing space for a merge field
hello,
I have the following formatting in a merge field in WORD. { IF { MERGEFIELD "ERSAL" } "" "{ MERGEFIELD "ERSAL" }" "" \* MERGEFORMAT } The display is now First Name I want it to be First Name What I am trying to do is remove the space that is associated with this merge field if it is blank in the data source. Right now if the field is blank, a space shows up. How can I eliminate the space as the one above doesn't work? Thanks BOB REYNOLDS 
|
|
#2
September 1st, 2004, 04:28 PM
|
|||
|
|||
|
You have a space in plain text in the merge document. Move this space into
the field result eg {IF{Mergefield ERSAL} "" " {Mergefield ERSAL}"} ie {IF{Mergefield ERSAL} "" "[space]{Mergefield ERSAL}"} Thus the space is placed when the field has content. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Bob Reynolds wrote: hello, I have the following formatting in a merge field in WORD. { IF { MERGEFIELD "ERSAL" } "" "{ MERGEFIELD "ERSAL" }" "" \* MERGEFORMAT } The display is now First Name I want it to be First Name What I am trying to do is remove the space that is associated with this merge field if it is blank in the data source. Right now if the field is blank, a space shows up. How can I eliminate the space as the one above doesn't work? Thanks BOB REYNOLDS
|
|
#3
September 1st, 2004, 04:49 PM
|
|||
|
|||
|
So simple, Thanks so much
Bob "Graham Mayor" wrote in message ... You have a space in plain text in the merge document. Move this space into the field result eg {IF{Mergefield ERSAL} "" " {Mergefield ERSAL}"} ie {IF{Mergefield ERSAL} "" "[space]{Mergefield ERSAL}"} Thus the space is placed when the field has content. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Bob Reynolds wrote: hello, I have the following formatting in a merge field in WORD. { IF { MERGEFIELD "ERSAL" } "" "{ MERGEFIELD "ERSAL" }" "" \* MERGEFORMAT } The display is now First Name I want it to be First Name What I am trying to do is remove the space that is associated with this merge field if it is blank in the data source. Right now if the field is blank, a space shows up. How can I eliminate the space as the one above doesn't work? Thanks BOB REYNOLDS
|
|
#4
September 1st, 2004, 05:54 PM
|
|||
|
|||
|
You are welcome
 -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Bob Reynolds wrote: So simple, Thanks so much Bob "Graham Mayor" wrote in message ... You have a space in plain text in the merge document. Move this space into the field result eg {IF{Mergefield ERSAL} "" " {Mergefield ERSAL}"} ie {IF{Mergefield ERSAL} "" "[space]{Mergefield ERSAL}"} Thus the space is placed when the field has content. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Bob Reynolds wrote: hello, I have the following formatting in a merge field in WORD. { IF { MERGEFIELD "ERSAL" } "" "{ MERGEFIELD "ERSAL" }" "" \* MERGEFORMAT } The display is now First Name I want it to be First Name What I am trying to do is remove the space that is associated with this merge field if it is blank in the data source. Right now if the field is blank, a space shows up. How can I eliminate the space as the one above doesn't work? Thanks BOB REYNOLDS
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Mail Merge Job Title field - PLEASE HELP | Bill | Mailmerge | 1 | August 27th, 2004 02:03 AM |
| Adding to "Insert Merge Field" Drop-down Menu | Jerome | Mailmerge | 1 | August 25th, 2004 09:55 AM |
| Mail Merge Field Formatting | Janet | Mailmerge | 2 | August 5th, 2004 01:53 AM |
| Blank Field merge error | James T. | Using Forms | 1 | July 22nd, 2004 06:47 PM |
Linear Mode
