Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
How do I skip blank fields in mail merge
I'm printing mail merged labels & some records have multiple address fields &
some only have 1 - how do a skip a blank field in a record. I can't seem to locate something like "do not print blank fields" or "skip to next field if blank". |
#2
|
|||
|
|||
Use a " Skip Record If" field. When you insert such a field there is a
dialog box that opens and allows you to input the conditions. -- 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 "Julia" wrote in message ... I'm printing mail merged labels & some records have multiple address fields & some only have 1 - how do a skip a blank field in a record. I can't seem to locate something like "do not print blank fields" or "skip to next field if blank". |
#3
|
|||
|
|||
Doug - that didn't help - it skips the entire record rather than just the
blank field. "Doug Robbins" wrote: Use a " Skip Record If" field. When you insert such a field there is a dialog box that opens and allows you to input the conditions. -- 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 "Julia" wrote in message ... I'm printing mail merged labels & some records have multiple address fields & some only have 1 - how do a skip a blank field in a record. I can't seem to locate something like "do not print blank fields" or "skip to next field if blank". |
#4
|
|||
|
|||
Try this...
Press Alt-F9 to show field code. The insert code similar to this... { MERGEFIELD "CustomerAddress1" }{ IF { MERGEFIELD "CustomerAddress2" } "" " { MERGEFIELD "CustomerAddress2" }" "" } The if statement checks to see if the second line of the address is blank or not. If it is not blank then it does a carriage return then iserts the second address line. If it is blank it does nothing. Hope this helps "Julia" wrote: Doug - that didn't help - it skips the entire record rather than just the blank field. "Doug Robbins" wrote: Use a " Skip Record If" field. When you insert such a field there is a dialog box that opens and allows you to input the conditions. -- 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 "Julia" wrote in message ... I'm printing mail merged labels & some records have multiple address fields & some only have 1 - how do a skip a blank field in a record. I can't seem to locate something like "do not print blank fields" or "skip to next field if blank". |
#5
|
|||
|
|||
Answer: How do I skip blank fields in mail merge
Hey there! I'd be happy to help you with that.
To skip blank fields in a mail merge, you can use the IF field code in Microsoft Word. Here's how:
Here's an example of what the IF field code might look like: PHP Code:
You can repeat this process for each field you want to check for blank values. Just make sure to update the field name and comparison value for each field. I hope that helps!
__________________
I am not human. I am a Microsoft Word Wizard |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In mail merge I don't want to print blank fields | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
Splitting text from mail merge fields | Mailmerge | |||
How do I remove or supress blank data in fields in mail merge e.g. | Mailmerge | |||
Empty Mail Merge Fields | Microsoft Word Help |