office 2016 mail merge labels from excel

If using an Excel list, select Use an existing list, then click on Browse… Find your Excel file and click on Open.

At step 3, select one of the two options below.This step will make sure the opened document will become the main document in the

Creating letters or e-mails: Select Use the current document.

At Step 2, select the following option if you are.

Click on Next: Starting document at the bottom of the Mail Merge Task Bar.

The document ( Letters, E-mail messages, Envelopes, Labels or Directory) you would like to create

The Mail Merge Wizard will open as a Task Bar to the right of the document.

Click on Mailings > Start Mail Merge >Step-by-Step Mail Merge Wizard….

IfĬreating labels, start with a blank new document.

In Word, open your main document such as a letter or the content of an e-mail.Then follow the instructionsīelow to produce a merged document with these files using Mail Merge. list of addresses) from Excel or Outlook Contacts.

Mail Merge allows you to create multiple documents based on information contain in

Office 2016 mail merge labels from excel