If for any reason you decide that you don’t want to print your own Labels, or you’re having trouble printing them, please give us a call. This way you can make sure that the Labels are printing properly before you print all the other Labels.
We recommend printing just one page of Labels to start. Now that you’ve done your mail merge and your Labels are setup correctly, the final step is to Print them. This last step will link your mailing address List with all your Labels.Īfter you select ‘Finish & Merge’, Word will open a new document, and you will see all your newly merged Labels! Step 5 : Print Your Labels! The last step of the mail merge is to select ‘Finish & Merge’.
#How to mail merge labels from excel to word on mac update
This will update all your other Labels so that they match the same format as your first Label. Once you’ve setup your first Label, then select ‘Update Labels’.
Or, you could create your own mailing address list, using the Names & Addresses of your current Contacts/Customers. If you want to grow your business and send an advertisement to prospective new customers, you can Buy a Mailing List online in an Excel file format and then use that list to setup your Labels. Once you’ve chosen your mailing address labels, the next step is setting up your mailing address list in Excel. Step 2 : Setup Your Mailing Address List in Excel You can purchase Avery 5160 Address Labels online at Amazon or Walmart (to name a few), or in your local stationary store. If you’re looking for standard, white, peel & stick Mailing Address Labels (which look great on Postcards & Envelopes), we recommend using Avery 5160 Mailing Address Labels. There are lots of different types of Address Labels to choose from. Step 1 : Choose Your Mailing Address Labels