Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
IF command to insert a comma if the Title field is not blank
I am merging a mailing list to a Word letter. I will be printing the person's
name followed by their title. How do I set up the IF command to insert a comma after the person's name if the Title field is not blank? I am using Word 2003. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
IF command to insert a comma if the Title field is not blank
Insert and If...then...Else... field from the Word Fields toolbar, or using
Ctrl+F9 to insert the field delimiters, create the following in the document { IF { MERGEFIELD Title } "" ", { MERGEFIELD Title }" } Use Alt+F9 to toggle off the display of field codes. -- 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 "K Hyzer" K wrote in message ... I am merging a mailing list to a Word letter. I will be printing the person's name followed by their title. How do I set up the IF command to insert a comma after the person's name if the Title field is not blank? I am using Word 2003. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
IF command to insert a comma if the Title field is not blank
This helped - I'm almost there. This does insert the title field, but not a
comma. This is what I put in the document: { IF {MERGEFIELD Title } "" ", {MERGEFIELD Title }" } Any suggestions? Thanks, Kim "Doug Robbins - Word MVP" wrote: Insert and If...then...Else... field from the Word Fields toolbar, or using Ctrl+F9 to insert the field delimiters, create the following in the document { IF { MERGEFIELD Title } "" ", { MERGEFIELD Title }" } Use Alt+F9 to toggle off the display of field codes. -- 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 "K Hyzer" K wrote in message ... I am merging a mailing list to a Word letter. I will be printing the person's name followed by their title. How do I set up the IF command to insert a comma after the person's name if the Title field is not blank? I am using Word 2003. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
IF command to insert a comma if the Title field is not blank
You probably did not use Ctrl+F9 for each pair of field delimiters. You
cannot insert the { } by using Shift plus the number 9 and 0 number keys (US Keyboard layout) -- 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 "K Hyzer" wrote in message ... This helped - I'm almost there. This does insert the title field, but not a comma. This is what I put in the document: { IF {MERGEFIELD Title } "" ", {MERGEFIELD Title }" } Any suggestions? Thanks, Kim "Doug Robbins - Word MVP" wrote: Insert and If...then...Else... field from the Word Fields toolbar, or using Ctrl+F9 to insert the field delimiters, create the following in the document { IF { MERGEFIELD Title } "" ", { MERGEFIELD Title }" } Use Alt+F9 to toggle off the display of field codes. -- 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 "K Hyzer" K wrote in message ... I am merging a mailing list to a Word letter. I will be printing the person's name followed by their title. How do I set up the IF command to insert a comma after the person's name if the Title field is not blank? I am using Word 2003. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
IF command to insert a comma if the Title field is not blank
or in Word 2003, try
{ MERGEFIELD Title \b ", " } Peter Jamieson "K Hyzer" wrote in message ... This helped - I'm almost there. This does insert the title field, but not a comma. This is what I put in the document: { IF {MERGEFIELD Title } "" ", {MERGEFIELD Title }" } Any suggestions? Thanks, Kim "Doug Robbins - Word MVP" wrote: Insert and If...then...Else... field from the Word Fields toolbar, or using Ctrl+F9 to insert the field delimiters, create the following in the document { IF { MERGEFIELD Title } "" ", { MERGEFIELD Title }" } Use Alt+F9 to toggle off the display of field codes. -- 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 "K Hyzer" K wrote in message ... I am merging a mailing list to a Word letter. I will be printing the person's name followed by their title. How do I set up the IF command to insert a comma after the person's name if the Title field is not blank? I am using Word 2003. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert a bookmark field | Microsoft Word Help | |||
Merge field delimiter in insert field formula ? | Mailmerge | |||
Help to merge Image (Doug Robins?) | Mailmerge | |||
How do I insert a field in a dialog box? | Microsoft Word Help | |||
How do I insert a field into a MS Word so I can use the first and | Mailmerge |