Let us take a small list for better understanding. A pop-up window is displayed allowing you to select the type of label you are creating (the most popular mailing labels are Avery 5160). From the Mail Merge options you want to select Labels. Click Start Mail Merge (in older versions of Word I believe this is called Mail Merge Wizard). Here is an example of a contact list to whom we will send emails, prepared in Excel. Open a new document in Word and go to the Mailings section. We will draft a letter in a Word document and will replace the default contact details with custom contact details.ĭon’t worry this easy tutorial can help you achieve this! ![]() Using the mail merge feature with Microsoft Word, you can do this task neatly and print out the mailing labels with ease directly from Excel. ![]() It provides features that can allow you to create labels and preview them before you print. Recommended Read: How to Create a Calendar in Excel? 1. Excel makes life easy in collaboration with Microsoft Word in printing mailing labels. To begin with, we will take an example of a sample contact list containing each person’s business address, company name, phone number, and email address, etc. ![]() You’re at the right place if this is your problem. You are probably here because you have 100 or 200 people to whom you want to send out a customized but identical email with the personal details of each person on your list. We will learn to use the mail merge tool with the help of crucial examples and supporting images. Let’s learn to mail merge a contact list from Microsoft Excel to MS Word.
0 Comments
Leave a Reply. |