how to print address labels from excel 2007

This will force Word to go to the next record.ģ. Use a Next Record rule beside each instance of the merge field that you want Word to move to the next record.

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.

How to print address labels from excel 2007