Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Optional field on labels Word 2002
I'm trying to create mailing lables in which would include a field only if it is non-blank. Also, the preceding separator would be omitted if the field is blank. E.g., James & Mary Brown .... .... or Bill Smith .... .... As opposed to Bill & Smith .... .... How can this be done when setting up the label layout? The source data is in an Excel spreadsheet. I know the basics of the process. TIA Ed |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Optional field on labels Word 2002
Use an If...then...Else field
{ IF { MERGEFIELD Spouse } "" " & { MERGEFIELD Spouse }" "" } Use Ctrl+F9 to insert each pair of field delimiters {} and Alt+F9 to toggle off their display. -- 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 "Ed" wrote in message ... I'm trying to create mailing lables in which would include a field only if it is non-blank. Also, the preceding separator would be omitted if the field is blank. E.g., James & Mary Brown ... ... or Bill Smith ... ... As opposed to Bill & Smith ... ... How can this be done when setting up the label layout? The source data is in an Excel spreadsheet. I know the basics of the process. TIA Ed |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Optional field on labels Word 2002
Thanks, Doug. I'll give it a try. Is there someplace where one can read about the full richness of the mailmerge syntax? Word Help seems oriented entirely toward the wizard. Ed "Doug Robbins - Word MVP" wrote in message ... Use an If...then...Else field { IF { MERGEFIELD Spouse } "" " & { MERGEFIELD Spouse }" "" } Use Ctrl+F9 to insert each pair of field delimiters {} and Alt+F9 to toggle off their display. -- 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 "Ed" wrote in message ... I'm trying to create mailing lables in which would include a field only if it is non-blank. Also, the preceding separator would be omitted if the field is blank. E.g., James & Mary Brown ... ... or Bill Smith ... ... As opposed to Bill & Smith ... ... How can this be done when setting up the label layout? The source data is in an Excel spreadsheet. I know the basics of the process. TIA Ed |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Optional field on labels Word 2002
Look at the articles on fellow MVPs Graham Mayor's website at
http://www.gmayor.com/multiple_mail_merge_entries.htm and Cindy Meisters at http://homepage.swissonline.ch/cindy...r/MergFram.htm -- 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 "Ed" wrote in message ... Thanks, Doug. I'll give it a try. Is there someplace where one can read about the full richness of the mailmerge syntax? Word Help seems oriented entirely toward the wizard. Ed "Doug Robbins - Word MVP" wrote in message ... Use an If...then...Else field { IF { MERGEFIELD Spouse } "" " & { MERGEFIELD Spouse }" "" } Use Ctrl+F9 to insert each pair of field delimiters {} and Alt+F9 to toggle off their display. -- 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 "Ed" wrote in message ... I'm trying to create mailing lables in which would include a field only if it is non-blank. Also, the preceding separator would be omitted if the field is blank. E.g., James & Mary Brown ... ... or Bill Smith ... ... As opposed to Bill & Smith ... ... How can this be done when setting up the label layout? The source data is in an Excel spreadsheet. I know the basics of the process. TIA Ed |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Optional field on labels Word 2002
I think you have quoted the wrong link from my web site? Try
http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Doug Robbins - Word MVP wrote: Look at the articles on fellow MVPs Graham Mayor's website at http://www.gmayor.com/multiple_mail_merge_entries.htm and Cindy Meisters at http://homepage.swissonline.ch/cindy...r/MergFram.htm "Ed" wrote in message ... Thanks, Doug. I'll give it a try. Is there someplace where one can read about the full richness of the mailmerge syntax? Word Help seems oriented entirely toward the wizard. Ed "Doug Robbins - Word MVP" wrote in message ... Use an If...then...Else field { IF { MERGEFIELD Spouse } "" " & { MERGEFIELD Spouse }" "" } Use Ctrl+F9 to insert each pair of field delimiters {} and Alt+F9 to toggle off their display. -- 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 "Ed" wrote in message ... I'm trying to create mailing lables in which would include a field only if it is non-blank. Also, the preceding separator would be omitted if the field is blank. E.g., James & Mary Brown ... ... or Bill Smith ... ... As opposed to Bill & Smith ... ... How can this be done when setting up the label layout? The source data is in an Excel spreadsheet. I know the basics of the process. TIA Ed |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word2000 letterhead merge | Mailmerge | |||
Underscore (_) will not always display in RTF files (Word 2002). | Microsoft Word Help | |||
Word 2002 and Word 2003 trading default file association | Microsoft Word Help | |||
is word perfect compatible with office word? | Microsoft Word Help | |||
Envelope Address | New Users |