![how to do a mail merge in word and excel how to do a mail merge in word and excel](https://www.lifewire.com/thmb/r7mOkxD0ICq0HZ8KAAg9i5kwv9g=/2157x1438/filters:no_upscale():max_bytes(150000):strip_icc()/InsertMergeFields-5bec439146e0fb0051644c15.jpg)
![how to do a mail merge in word and excel how to do a mail merge in word and excel](https://www.clientlook.com/wp-content/uploads/How-To-Mail-Merge_1.png)
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.This can be Date, Currency, Percent or some other field. Select the merge field whose format you want to change. If you want to have the numbers, dates or currencies formatted in a different way than in your Excel mail merge source file, you can do this directly in a Word document. The document ( Letters, E-mail messages, Envelopes, Labels or Directory) you would like to create Format date, time, number and currency during mail merge in Word.
![how to do a mail merge in word and excel how to do a mail merge in word and excel](https://www.lifewire.com/thmb/VDqo-jqVrQ0jFqdTUKwSlyhYs5g=/1327x746/smart/filters:no_upscale()/ExcelData-5bec4181c9e77c0026283623.jpg)
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