Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Comma
How do I insert a comma only before a merge field that is populated? In
other words, no comma if the merge field following the comma is blank. |
#2
|
|||
|
|||
You could use
{ IF "{ MERGEFIELD myfield }" = "" "" ",{ MERGEFIELD myfield }" } or in Word 2003 and probably 2002 just { MERGEFIELD myfield \b , } should be enough. You can do the latter by selecting the field and right-clicking, then Edit Field and fill in the relevant option. otherwise, use Alt-F9 to view the full field codes, ctrl-F9 to insert each pair of the special field braces {}, and type the remaining text. Peter Jamieson "chartley" wrote in message ... How do I insert a comma only before a merge field that is populated? In other words, no comma if the merge field following the comma is blank. |
#3
|
|||
|
|||
Thank you!
"Peter Jamieson" wrote: You could use { IF "{ MERGEFIELD myfield }" = "" "" ",{ MERGEFIELD myfield }" } or in Word 2003 and probably 2002 just { MERGEFIELD myfield \b , } should be enough. You can do the latter by selecting the field and right-clicking, then Edit Field and fill in the relevant option. otherwise, use Alt-F9 to view the full field codes, ctrl-F9 to insert each pair of the special field braces {}, and type the remaining text. Peter Jamieson "chartley" wrote in message ... How do I insert a comma only before a merge field that is populated? In other words, no comma if the merge field following the comma is blank. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
currency with auto decimal and comma separator in a table | Tables | |||
Why is there a comma in the second line of the mail merge wizard | Mailmerge | |||
How do I sort a single comma separated list? | Microsoft Word Help | |||
comma delimited text | Mailmerge | |||
Can I change mail merge lables to delete-exclude the comma ? ... | Mailmerge |