Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-02-2015, 02:03 PM
Delta223 Delta223 is offline Skipping USA as a country identifier Windows 8 Skipping USA as a country identifier Office 2013
Novice
Skipping USA as a country identifier
 
Join Date: Dec 2009
Posts: 7
Delta223 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 04-03-2015, 02:27 AM
gmayor's Avatar
gmayor gmayor is offline Skipping USA as a country identifier Windows 7 64bit Skipping USA as a country identifier Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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
Reply With Quote
Reply



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
Skipping USA as a country identifier data roll up under unique identifier NewGirl Mail Merge 1 11-15-2012 04:47 PM
Skipping USA as a country identifier 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft