#1
|
|||
|
|||
Skipping USA as a country identifier
Hi, is there a way to skip "USA" in the country field? I have a mix of US and Canadian addresses, and I only want to specify Canada where appropriate. Also, if I use an address block, will it automatically skip lines with no information? I'm most concerned about address line 2 |
#2
|
||||
|
||||
Don't use the address block! Use the individual fields. You can conditionally insert fields including country fields or address lines. e.g. (as there are only two countries involved)
{ IF { MERGEFIELD COUNTRY } <> "U*" "{ MERGEFIELD COUNTRY }" } You can insert a paragraph break within the brackets if you wish to conditionally insert the line break before the field. In the case of missing field data you can treat that in the same way e.g. { MERGEFIELD FIRSTNAME } { MERGEFIELD LASTNAME }{ IF { MERGEFIELD COMPANY } <> "" "¶ { MERGEFIELD COMPANY }" }{ IF { MERGEFIELD ADDRESS1 } <> "" "¶ { MERGEFIELD ADDRESS1 }" }{ IF { MERGEFIELD ADDRESS2 } <> "" "¶ { MERGEFIELD ADDRESS2 }" }¶ { MERGEFIELD ADDRESS3 }¶ etc ¶ = Press the enter key.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Skipping row in mail merge table. | Mulith | Mail Merge | 6 | 10-30-2014 04:32 AM |
Mail merge--skipping records | 623bookends | Mail Merge | 2 | 01-12-2014 06:02 AM |
data roll up under unique identifier | NewGirl | Mail Merge | 1 | 11-15-2012 04:47 PM |
Skipping pages in a mail merge | NewGirl | Mail Merge | 6 | 12-16-2011 07:16 AM |
Adding a country drop-down list | iyavor | Word | 0 | 10-27-2010 03:51 AM |