| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mergefield conditional, need to skip blank line
Hello,
I am using Mailmerge and have created some conditional formatting in order to skip certain fields if the data is blank. However, now the blank lines are being left in my document. Is there another mergefield code I can use to remove blank lines? Here is what I have so far: First three lines are fine, blank lines are skipped because there is no conditional formatting: { MERGEFIELD First_Name } { MERGEFIELD Last_Name } { MERGEFIELD AgencyCompany } { MERGEFIELD Address } Then the fourth line is this: { IF{ MERGEFIELD City } { MERGEFIELD City } }{ IF{ MERGEFIELD State } {MERGEFIELD State } }{ IF{ MERGEFIELD Zip_Code } { MERGEFIELD Zip_Code } } I would like to tell the fourth line to skip if it is blank. Any help would be appreciated. Thank you! -- Julie ~ Former WordPERFECT user. Attempting to soak up all the knowledge from other generous Word & Excel users to make my job easier. |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mergefield conditional, need to skip blank line
Hi Julie,
Assuming you mean that you only want to suppress the line if the City, State and Zip Code are all *blank*, you could code the field like: {IF{QUOTE "{MERGEFIELD City}{MERGEFIELD State}{MERGEFIELD Zip_Code}"}= "" "" "ΒΆ{IF{MERGEFIELD City} "" "{MERGEFIELD City} "}{IF{MERGEFIELD State} "" "{MERGEFIELD State} "}{MERGEFIELD Zip_Code}"} and attach it to your {MERGEFIELD Address} line. Note the absence of spaces between the fields embedded within the QUOTE field, and the 'ΒΆ'. You'd insert a real paragraph mark or line-feed into the code at the 'ΒΆ' point. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Julie B" wrote in message ... Hello, I am using Mailmerge and have created some conditional formatting in order to skip certain fields if the data is blank. However, now the blank lines are being left in my document. Is there another mergefield code I can use to remove blank lines? Here is what I have so far: First three lines are fine, blank lines are skipped because there is no conditional formatting: { MERGEFIELD First_Name } { MERGEFIELD Last_Name } { MERGEFIELD AgencyCompany } { MERGEFIELD Address } Then the fourth line is this: { IF{ MERGEFIELD City } { MERGEFIELD City } }{ IF{ MERGEFIELD State } {MERGEFIELD State } }{ IF{ MERGEFIELD Zip_Code } { MERGEFIELD Zip_Code } } I would like to tell the fourth line to skip if it is blank. Any help would be appreciated. Thank you! -- Julie ~ Former WordPERFECT user. Attempting to soak up all the knowledge from other generous Word & Excel users to make my job easier. |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mergefield conditional, need to skip blank line
Macropod,
Thank you sooooo much! I squealed with delight when it worked, because I had been trying to figure out something on my own for days. I just love coming to these discussion boards to find people who know everything about the programs that I despise. It helps me do my job better! Thanks again!!! -- Julie ~ Former WordPERFECT user. Attempting to soak up all the knowledge from other generous Word & Excel users to make my job easier. "macropod" wrote: Hi Julie, Assuming you mean that you only want to suppress the line if the City, State and Zip Code are all *blank*, you could code the field like: {IF{QUOTE "{MERGEFIELD City}{MERGEFIELD State}{MERGEFIELD Zip_Code}"}= "" "" "ΒΆ{IF{MERGEFIELD City} "" "{MERGEFIELD City} "}{IF{MERGEFIELD State} "" "{MERGEFIELD State} "}{MERGEFIELD Zip_Code}"} and attach it to your {MERGEFIELD Address} line. Note the absence of spaces between the fields embedded within the QUOTE field, and the 'ΒΆ'. You'd insert a real paragraph mark or line-feed into the code at the 'ΒΆ' point. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Julie B" wrote in message ... Hello, I am using Mailmerge and have created some conditional formatting in order to skip certain fields if the data is blank. However, now the blank lines are being left in my document. Is there another mergefield code I can use to remove blank lines? Here is what I have so far: First three lines are fine, blank lines are skipped because there is no conditional formatting: { MERGEFIELD First_Name } { MERGEFIELD Last_Name } { MERGEFIELD AgencyCompany } { MERGEFIELD Address } Then the fourth line is this: { IF{ MERGEFIELD City } { MERGEFIELD City } }{ IF{ MERGEFIELD State } {MERGEFIELD State } }{ IF{ MERGEFIELD Zip_Code } { MERGEFIELD Zip_Code } } I would like to tell the fourth line to skip if it is blank. Any help would be appreciated. Thank you! -- Julie ~ Former WordPERFECT user. Attempting to soak up all the knowledge from other generous Word & Excel users to make my job easier. |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I skip blank lines when line numbering? | Page Layout | |||
| If the mergefield is blank, delete the line. | Mailmerge | |||
| How do I skip page line numbers for blank lines?? | Page Layout | |||
| How do I skip line numbering on blank lines? | Page Layout | |||
| How to skip line numbers for all blank lines in a document | Page Layout | |||
Linear Mode
