|
#1
|
|||
|
|||
MailMerge - removing empty row
Hi all,
I'm completely newbie in word mailmerge and Word VBA. I have an excel file, where I have 1 column linked to Word via mailmerge where output of it is a template of agreement for employees. In that column I have complex formula which concatenated multiple articles where is a change for employee. If there s no change is shows me "". As each article should have his own row in word, when there is no changes in article it gives me automatically empty row Is there any option to remove that or setup it in mail merge, only? Find and replace in this case does not work, as this is removing me empty rows from the whole template, which I actually need but not from mailmerge. Attaching the empty sample with my specific mailmerge. Thanks, Andy |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to insert an image to a word mailmerge document based on the value of a mailmerge field? | Jake93 | Mail Merge | 3 | 07-02-2019 05:38 PM |
Removing spaces in activedocument after empty bookmarks | faustino909 | Word VBA | 2 | 08-03-2018 01:34 PM |
Removing Empty Brackets In Batch | Agog | Word VBA | 16 | 07-16-2018 05:39 AM |
Removing Return from Address field in Mailmerge | Formd | Mail Merge | 2 | 04-27-2015 10:07 PM |
Apparently empty (blank) cells aren't empty | daymaker | Excel | 3 | 03-08-2012 03:41 PM |