Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
separating numeric fields
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
separating numeric fields
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. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
separating numeric fields
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. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
separating numeric fields
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. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
separating numeric fields
{ 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. |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
separating numeric fields
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with numeric blank fields | Mailmerge | |||
Use of fields in templates | Microsoft Word Help | |||
mail merge and text form fields | Mailmerge | |||
Mail Merge Numeric Merge Fields | Mailmerge | |||
Word crashing upon re-use of a template | Microsoft Word Help |