Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I code an If Then Else field when...
I'm trying to create address labels through a mail merge and move up
remaining lines if a data field is blank. For example: Some of the addresses do not include an organization name. If this is the case, an awkward blank line is left between the name and the street address. How do I code it so that the lines move up if the organization field is blank? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I code an If Then Else field when...
{ IF { MERGEFIELD Organization }= "" "{ MERGEFIELD Address }" "{ MERGEFIELD
Organization }[line feed]{ MERGEFIELD Address }" } Use Shift+Enter where [line feed] appears in this 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 "Llawler" wrote in message ... I'm trying to create address labels through a mail merge and move up remaining lines if a data field is blank. For example: Some of the addresses do not include an organization name. If this is the case, an awkward blank line is left between the name and the street address. How do I code it so that the lines move up if the organization field is blank? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I code an If Then Else field when...
Thanks for the code, Doug. I thought I knew where it goes, but I'm lost.
Thanks. "Doug Robbins - Word MVP" wrote: { IF { MERGEFIELD Organization }= "" "{ MERGEFIELD Address }" "{ MERGEFIELD Organization }[line feed]{ MERGEFIELD Address }" } Use Shift+Enter where [line feed] appears in this 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 "Llawler" wrote in message ... I'm trying to create address labels through a mail merge and move up remaining lines if a data field is blank. For example: Some of the addresses do not include an organization name. If this is the case, an awkward blank line is left between the name and the street address. How do I code it so that the lines move up if the organization field is blank? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I format zip code merge field to add hyphen if zip plus 4? | Mailmerge | |||
Enter text in a field and have it appear as entered elsewhere | Microsoft Word Help | |||
Print field code shading | Microsoft Word Help | |||
How do I replace one character with another in the field code resu | Mailmerge | |||
Incrementing field code | Mailmerge |