After you find the file, click on the range or sheet within the workbook that has the table with the address information and click OK.Ĥ. Next, find the Excel file that contains the address information for the mailing labels. Next, go to Mailings>Start Mail Merge>Select Recipients>Use Existing List and the “Select Data Source” pop up window box will appear. Now before moving on to the next step, go to Table Tools Layout>Table>View Gridlines, so that you can see the gridlines of the mailing labels.ģ. Under “Printer Information” select “Page printers” and under “Label information” select “Avery US Letter,” and finally, under “Product number” you need to find the size of the labels you will be using for the mail merge. Open Microsoft Word 2007 and go to Mailings>Start Mail Merge>Labels, and the “Label Options” pop up window box will appear.Ģ. First, ensure you have the Excel workbook where you have all the address data securely saved and accessible, although, you don’t need to have it open to create the mail merge. I will show you how to create a mailing label merge using Excel and Word, so that you can mail out your wonderful created letters from the successful mail merge in the previous tutorial.ġ.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |