
If you need to leave the spaces in your Excel file, you can just tell Microsoft Word to ignore those blank rows. Having blank lines in your Excel file can mess up your mail merge. Word Is Merging The Blank Rows In My Excel File

If you’re using a different barcode font, check to see what alternative leading and trailing symbols there are for your barcode.Ħ. Asterisks usually mean something needs to be bolded and can confuse Microsoft Word. Use parenthesis instead of asterisks for Code 39 barcodes in Microsoft Word. Code 39 Leading & Trailing Asterisks Not Working

Having multiple copies of the same merge field on the same page can cause the first record to be repeated in all instances of the merge field on that page. Make sure any leading and trailing characters are right next to the merged field and don’t have any spaces between them and the merged field. If your barcodes aren’t working correctly, check for extra spaces around the merged field. Microsoft Word can sometimes add in extra spaces where you don’t want them. We’re going to look at some of the most common problems and look at how to fix them. Since Microsoft Word looks at all of the pages as a whole vs Microsoft Publisher which looks at a single instance of your project, some problems can arise in Microsoft Word when mail merging.

It’s easier to do mail merging in Microsoft Publisher, but it’s possible to do a nice mail merge in Microsoft Word.
