Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to skip a field in a directory mail merge if it's blank
I am trying to do a directory mail merge from excel. In some cases - there
is no phone number so the field is blank. How do I get the merge to skip that part and go to the next entry? Below is a copy of my merge fields. I am trying to get Word to skip printing "Home........ " if there is no text in the Home field. «S»«LAST_», «Salutation» «Street», «City», «ST» «ZIP» Home€¦€¦€¦€¦€¦€¦ «Home» Dad Work€¦€¦€¦€¦ «Dads_WK» Dad Cell€¦€¦€¦€¦€¦ «Dads_Cell» Mom Work€¦€¦€¦... «Moms_WK» Mom Cell€¦€¦€¦€¦... «Moms_Cell» Dad Email€¦€¦€¦.«Dads_Email» Mom Email€¦€¦...«Moms_Email» Family Email€¦€¦Â«Family_Email» «ST_FN_1» «ST_LN_1» «GR_1» «ST_FN_2» «ST_LN_2» «GR_2» «ST_FN_3» «ST_LN_3» «GR_3» «ST_FN_4» «ST_LN_4» «GR_4» |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to skip a field in a directory mail merge if it's blank
Use an If...then...Else... field construction like
{ IF { MERGEFIELD Home } "" "Home[tab]{ MERGEFIELD Home }[enter]Dad Work[tab]{ MERGEFIELD Dads_WK }" "Dad Work[tab]{ MERGEFIELD Dads_WK }" } where in place of [tab] and [enter] you use the Tab key and the Enter key respectively. You must 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 "Marisa" wrote in message ... I am trying to do a directory mail merge from excel. In some cases - there is no phone number so the field is blank. How do I get the merge to skip that part and go to the next entry? Below is a copy of my merge fields. I am trying to get Word to skip printing "Home........ " if there is no text in the Home field. «S»«LAST_», «Salutation» «Street», «City», «ST» «ZIP» Home...... «Home» Dad Work.... «Dads_WK» Dad Cell..... «Dads_Cell» Mom Work...... «Moms_WK» Mom Cell....... «Moms_Cell» Dad Email....«Dads_Email» Mom Email.....«Moms_Email» Family Email..«Family_Email» «ST_FN_1» «ST_LN_1» «GR_1» «ST_FN_2» «ST_LN_2» «GR_2» «ST_FN_3» «ST_LN_3» «GR_3» «ST_FN_4» «ST_LN_4» «GR_4» |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I mail merge to EMAIL from MS Word AND add a pdf attachment | Mailmerge | |||
mail merging formatted content | Mailmerge | |||
Mail merge and blank fields | Mailmerge | |||
Form Letter Mail Merge using field code: {Database} | Mailmerge | |||
Mail Merge from Excel - conditional field choice? | Mailmerge |