![]() |
#1
|
|||
|
|||
![]()
I am trying to use the Mail Merge in Word 2010 with an Excel 2010 spreadsheet to print a phone roster. Everything works fine except where for various reasons there in no city, state, or zip.
What I have in my mail merge document is: <<Name>>In some of the "street" fields I have inserted the phrase "Withheld by Request" or "DECEASED" rather than a street address. The "City, State, and Zip" fields are then intentionally left blank in my spreadsheet. What I get on the printout is : John DoeWhat I would like to have print out is the following: John DoeWhere the ", " is NOT printed if the "city, state zip" fields are empty and the " / " does not print if one or both of the phone fields are blank. Any or all suggestions would be appreciated. Right Now I am going through the generated document and manually having to delete or use the replace command to get rid of the unwanted characters. Thanks! Last edited by DHammer; 05-30-2014 at 01:40 AM. Reason: correct display error |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
RobDuBois | Word | 3 | 01-20-2013 04:40 PM |
![]() |
Learner7 | Excel | 1 | 04-25-2011 04:39 AM |
"Inserting" 11x17 blank sheet into report | mcjohn | Word | 2 | 01-06-2010 09:14 AM |
"Intentionally left in Blank" Pages | Manolo | Word | 2 | 04-30-2009 04:20 AM |
![]() |
rnstewart | Excel | 2 | 12-28-2005 04:30 PM |