When you’re doing a mail merge in Microsoft Word (see this video: https://youtu.be/efwtPGdOWGI), it’s common to have missing data, such as a company name or an “address 2” line. In these cases, you don’t want a blank line to appear on your label (or letter or envelope), but you want it to be skipped entirely.
In a hands-on tutorial, I’ll show you two ways to get around this issue.
00:00 – Dealing with missing data for a mail merge in Microsoft Word
00:41 – Setting up a new mail merge document for labels in Microsoft Word
02:07 – Where the problem begins with the blank lines
02:53 – FIX #1: Finding and replacing blank lines in the final merged document (after the fact)
04:18 – FIX #2: Updating the merge field to remove the extra line at merge time (before the fact)
