steps to mail merge from excel to word for labels

Use the arrow buttons between Recipient on the Task Bar to preview the information from the data source in your main document.

Click on Next: Preview your letters, Labels or e-mail message to do just that.

Next, click in between each merge field, outside the chevron symbols ( »|«), and add spaces and any punctuation needed to separate the Merge Fields (see below).

«First_Name»«Last_Name»«Street1_Line1»«City»«State»«Zip_Code»

With the cursor in place, click on More items… Double click on all the Merge Fields needed to complete your document.

If the main document are labels, the cursor will be at the first labelīy default.

At step 4, click on the main document to position the cursor where the Merge Fields.

Click on Next: Write your letter or e-mail message (if creating an e-mail).

Click on OK to complete the selection of the list.

Select your contact folder from the list and click on OK

If using Outlook Contacts, click on Select from Outlook contacts and Choose Contacts Folder.

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

Steps to mail merge from excel to word for labels