How to Mail Merge

How to Mail Merge

Creating a mail merge email 

The excel file you are merging with must be located on your computer (as opposed to the cloud). 

Open your word file and select mailings: 

 

Choose Start Mail Merge and select type of mail: 

 

 

Note – email messages will go out from your default email (see documentation on changing the default email) 

Choose select recipients: 

 

 

‘Use an existing list’ will open the option to add an excel file. 

 

Select the sheet to attach (more often than not, you will have just 1 sheet) 

 

To insert information into the letter, set the cursor where you want to add information and select Insert Merge Field.  Choose what information you want added to the document. 

 

 

Select Preview Results: 

 

Once it is pulling the information is correct, select Finish and Merge 

 

 

Send Email Messages and add subject line 

 

Once you press ok, it will send the email.  It does take a moment to complete, depending on the number of emails sent out.