Moving merged fields might seem like a touchy issue, but it’s really no different than moving regular text. Try not to use text boxes when mail merging with multiple copies of a Merge Field on the same page. You can’t put rules (like the Next Record rule) in text boxes. First Record Works But Second Record Does Not Work in Text Box When box pops up click Show All in the bottom leftĩ.Check Confirm Conversion at Openįor Word 2007 and up: Office Button, Word Options, Advanced, near bottom Confirm file format conversion on open For Word versions previous to 2007: Tools, Options, General tab.Word will display your dates, prices, and other numbers in an odd layout. This is a problem with the connection between Word and Excel.
![how to do a mail merge microsoft word 2016 how to do a mail merge microsoft word 2016](https://www.dummies.com/wp-content/uploads/497596.image0.jpg)
Either have your Next Records after your Merged Fields or before them don’t change it up as this can cause confusion. The second Next Record will cause a record to be skipped. This will tell Word to ignore those blank rows in Excel.Ĭheck for extra next record rules in your document. Go to Edit Recipient List and uncheck the blank rows. 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
![how to do a mail merge microsoft word 2016 how to do a mail merge microsoft word 2016](https://connections-pro.com/wp-content/uploads/screenshot-word-2016-mailing-tab.png)
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.
#How to do a mail merge microsoft word 2016 code
Use parenthesis instead of asterisks for Code 39 barcodes in Microsoft Word. Code 39 Leading & Trailing Asterisks Not Working
#How to do a mail merge microsoft word 2016 how to
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.
![how to do a mail merge microsoft word 2016 how to do a mail merge microsoft word 2016](https://www.addintools.com/documents/word/images/shot-classic-mail-merge.png)
It’s easier to do mail merging in Microsoft Publisher, but it’s possible to do a nice mail merge in Microsoft Word.