#1
|
|||
|
|||
Suppress blanks in mail merge
Hi guys,
I've searched and searched and not been able to come up with an answer. If I have information as below: Add_1: 19 Smith Road Add_2: Holyroyd Add_3: Add_4: Chorlston Add_5: Add_6: MK12RR Can you tell me how I merge it so it suppresses blanks and shows as follows: 19 Smith Road Holyroyd Chorlston MK12RR Thus removing any blanks and making everything look nice and neat. I've been messing around with If statements but can only seem to get one of those - for example If address 2 is blank then print address 3 but this doesn't shift everything else up. Any suggestions? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge in Word: creating a rule for blanks | cgranada | Mail Merge | 6 | 02-27-2017 09:08 AM |
Easy mail merge but want to suppress rows | ClaireAMAdams | Mail Merge | 5 | 04-30-2013 02:43 PM |
Conditional merge fields in mail merge | Aude | Mail Merge | 1 | 01-06-2012 07:38 PM |
fill blanks in box | keevitaja | Word | 1 | 05-23-2011 06:34 PM |
Suppress Dialog Box | crutch024 | Word | 0 | 08-17-2010 09:52 AM |