Mail Merge allows you to create multiple documents based on information contain in two different files. You’ll need the main document (e.g. a letter), and a data source (e.g. list of addresses) from Excel or Outlook Contacts. Then follow the instructions below to produce a merged document with these files using Mail Merge.
In Word, open your main document such as a letter or the content of an e-mail. If creating labels, start with a blank new document.
The Mail Merge Wizard will open as a Task Bar to the right of the document. Select the document (Letters, E-mail messages, Envelopes, Labels or Directory) you would like to create
At Step 2, select the following option if you are
Creating letters or e-mails: Select Use the current document. This step will make sure the opened document will become the main document in the process
Under Tray, select Manual Feed (Place your label paper facing up on the manual feed tray of your printer and open the rear output tray)
Under Label vendors, make sure Avery US Letter is selected.
Then under Product number, find the label that matches the label number on the Avery label box.
At step 3, select one of the two options below
will be added. If the main document are labels, the cursor will be at the first label by default. Just add the Merge Fields there
Select one of the following option depending on what you are creating
If creating letters or labels
The last step is to either Print or Save the document for later use
If creating e-mail messages
account (e.g. your office account). Word will use this account to send the e-mail messages
At the To prompt, select the Merge Field containing the e-mail addresses.