Go to the mailings tab choose start mail merge and click on labels. Its time to connect to your excel address list to merge the address information with your mailing labels. To create and print the mailing labels you must first prepare the worksheet data in excel and then use word to configure organize review and print the mailing labels. Insert the label paper into your printer. You can also select new label if you want to enter custom label dimensions.
How to mail merge labels from excel 2007 how to#
How to print mailing labels from excel address list example written by co founder kasper langmann microsoft office specialist. Create and print mailing labels for an address list in excel if you want to send a mass mailing to an address list that you maintain in a microsoft excel spreadsheet you can use a microsoft word mail merge. Print labels for your mailing list with your address list set up in an excel spreadsheet outlook contacts or you create a new list use mail merge in word to create mailing labels.
How to mail merge labels from excel 2007 Pc#
How to create address labels from excel on pc or mac printing the labels open the label document in word. The mail merge process creates a sheet of mailing labels that you can print and each label on the sheet contains an address from the list. In the insert address block window that appears click the match fields button. The fastest and most effective way to print labels from your excel.Ĭhoose to use an existing list under select recipients.
Now its time to add your mail merge fields in words labels. Select the first label switch to the mailings tab and then click address block.
How To Mail Merge And Print Labels In Microsoft Word Column names in your spreadsheet match.
0 kommentar(er)
