I have several numeric fields that I need to insert into my merge document.
Problem is, I need to separate them, using commas preferably. All letters do
not contain the same number of numeric data, so I will need to suppress blank
data fields. Any help would be greatly appreciated.

Use and If...then...Else... field construction.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"DeborahKea" wrote in message
...
I have several numeric fields that I need to insert into my merge document.
Problem is, I need to separate them, using commas preferably. All letters
do
not contain the same number of numeric data, so I will need to suppress
blank
data fields. Any help would be greatly appreciated.

Okay....Where would I find that? As a side note, before XP, I used to be able
to process any mail merge. Now everything requires codes & switches, and I
don't have a clue!!~!

"Doug Robbins - Word MVP" wrote:

Use and If...then...Else... field construction.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"DeborahKea" wrote in message
...
I have several numeric fields that I need to insert into my merge document.
Problem is, I need to separate them, using commas preferably. All letters
do
not contain the same number of numeric data, so I will need to suppress
blank
data fields. Any help would be greatly appreciated.

Doug,
I found the If, then, else field merge, but can you explain to me how to
seperate numeric field with commas using this function?


"Doug Robbins - Word MVP" wrote:

Use and If...then...Else... field construction.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"DeborahKea" wrote in message
...
I have several numeric fields that I need to insert into my merge document.
Problem is, I need to separate them, using commas preferably. All letters
do
not contain the same number of numeric data, so I will need to suppress
blank
data fields. Any help would be greatly appreciated.

{ MERGEFIELD Number1}{IF { MERGEFIELD Number2 } "" ", { MERGEFIELD
Number2 }" "" }{IF { MERGEFIELD Number3 } "" ", { MERGEFIELD Number3 }"
"" } etc.

Use Ctrl+F9 to insert each pair of field delimiters and Alt+F9 to toggle
their display.

Note that this has not changed from earlier versions of Word.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"DeborahKea" wrote in message
...
Doug,
I found the If, then, else field merge, but can you explain to me how to
seperate numeric field with commas using this function?


"Doug Robbins - Word MVP" wrote:

Use and If...then...Else... field construction.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"DeborahKea" wrote in message
...
I have several numeric fields that I need to insert into my merge
document.
Problem is, I need to separate them, using commas preferably. All
letters
do
not contain the same number of numeric data, so I will need to suppress
blank
data fields. Any help would be greatly appreciated.

You can actually achieve that with switches, but in both cases there will be
a stray leading comma if the Number1 field is empty eg

{ MERGEFIELD Field1 \# ",0.00;,-0.00"; }{ MERGEFIELD Field2 \# "',
',0.00;', ',-0.00;" }{ MERGEFIELD Field3 \# "', ',0.00;', ',-0.00;" }


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Doug Robbins - Word MVP wrote:
{ MERGEFIELD Number1}{IF { MERGEFIELD Number2 } "" ", { MERGEFIELD
Number2 }" "" }{IF { MERGEFIELD Number3 } "" ", { MERGEFIELD
Number3 }" "" } etc.

Use Ctrl+F9 to insert each pair of field delimiters and Alt+F9 to
toggle their display.

Note that this has not changed from earlier versions of Word.


"DeborahKea" wrote in message
...
Doug,
I found the If, then, else field merge, but can you explain to me
how to seperate numeric field with commas using this function?


"Doug Robbins - Word MVP" wrote:

Use and If...then...Else... field construction.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of
my services on a paid consulting basis.

Doug Robbins - Word MVP

"DeborahKea" wrote in message
...
I have several numeric fields that I need to insert into my merge
document.
Problem is, I need to separate them, using commas preferably. All
letters
do
not contain the same number of numeric data, so I will need to
suppress blank
data fields. Any help would be greatly appreciated.