Tip: If you want to add a picturea logo, for exampleto the rizzoli and isles season 4 episode 10 label and have it appear before the address block, it's best to do so now.
Open up Excel and enter some headings on the first row: These headings will be used by Word to identify your data.
In the Insert Address Block dialog box, choose a format for the recipient's name as it will appear on the label.Step 3: Link your mailing list to your labels On the Mailings tab, in the Start Mail Merge group, choose Select Recipients, and then choose one of the following: If you dont have a mailing list, choose Type a New List and create one.6, click on "More items." and insert the fields you want to add, then click "Close." 7, go to your Word document and arrange the fields on your page so they are positioned the way you want.Choose the Next record button or the Previous record button to make sure the names and addresses on all the labels look right.On the Mailings tab, in the Write Insert Fields group, choose Match Fields.We'll use this later with the mail merge.Address_List as the file name: Take note of where the file is being saved, and the file type.You can use the same (fictitious) information.Post a question in the Word community forum Help us improve Word Do you have suggestions about how we can improve mail merge (or any other feature) of Word?Or If youre using your Outlook contacts, choose Choose from Outlook Contacts.For tips about working with pictures, see Insert pictures in Office 2013 and Office 2016.On the Insert tab, choose Pictures, find the file you want, select it, and then choose Insert.
Step 2: Prepare the main document for the labels.
We're going to create a Mail Merge for a letter.
When you insert a percentage into Word from Excel during a mail merge, the number's format changes.
Applies To: Word 20 Word 20 Word Starter 2010.
Use Excel as a Data Source for Mail Merge You can use an Excel spreadsheet as your data source for a Microsoft Word Mail Merge.In Layout Options, you can position the picture by choosing Square or Tight.Next time you open the mail merge document, choose Yes when Word prompts you to keep the connection.These are the documents involved in creating and printing labels using the mail merge process: Your main document, this is the document you use to set up the layout of the labels in the mail merge.It contains the records Word pulls information from to build the addresses for the labels.On the Mailings tab, choose Preview Results.