#Putting addresses in word for labels how to

In the example below, I have four names in my database: Bob Awesome, Sally Brown, Susan Cool, and WhereРІР‚в„ўs Waldo. I would have thought that this was a common issue with mailmerge address fields but have searched here and googled and I can only seem to find similar questions with no solutions attached. The Next Record Rule is simply another field that tells Microsoft Word to go to the next record (a record refers to a row in your mail merge database/spreadsheet). I think I'm getting close to working it out but it's driving me mad! Choose Label Options and your label manufacturer from the list given, along with the product number for your labels Click Next: Select Recipients and Browse A window will pop up, showing you files and folders. 1- Before inserting an address block in your letters, insert some blank lines before Greeting line part. This worked in scenarios where the address was 5 lines but if more or less, it would not behave and would either not show the postcode at all, OR show it twice. I have tried setting up if then else rules and I made the assumption that all addresses would have at least 3 lines included so the first rule in place was Obviously if all addlines are used, it looks fine. WordTips is your source for cost-effective Microsoft Word training. Note that the numbers are sorted alphabetically rather than numerically, so you have to go down past all the 1s (even five-digit ones), 2s, 3s, and 4s to get to the 5s. Your labels should now be centered vertically. In the Label Options dialog, for 'Label vendor,' select 'Avery US Letter.' In the 'Product number' box, scroll down to 5520. Repeat steps 3 through 5 for each label on the sheet. Keep pressing Delete until the end-of-cell marker is at the end of the line. Press Delete to delete the paragraph marker. Where the address only has addlines 1-4 and a postcode, I'm getting blank lines between addline4 and the postcode. Press the End key to move to the end of the line. Now move your cursor to the first label, and click 'Insert Merge Field. Select 'Use Existing List' from the drop-down menu, and locate the Excel file which you save on your computer.

#Putting addresses in word for labels how to

2 thoughts on How to use addresses from an Excel worksheet to create labels in Word. I have a document that has 7 mailmerge address fields addline1, addline2, addline3, addline4, addline5, addline6, Postcode. Click the Select Recipients button, located right besides the Start Mail Merge button. For more information about how to create a mail-merge address list. I have been looking into this all morning and am really hoping there is a simple solution to this.