Body
Open Outlook, loading the profile configured with email address from which you want to send the messages.
Open Microsoft Word and compose your message in Word like you would compose any other document. Once the message is ready:
Click on Mailings >> Start Mail Merge >> E-mail Messages
![](https://ppm.smu.ca/TDPortal/Images/Viewer?fileName=ffd9231c-e039-4a43-87e1-d414001480d3.png)
Click on Select Recipients >> Use an Existing List
![](https://ppm.smu.ca/TDPortal/Images/Viewer?fileName=5f5928b1-880e-4555-a383-577e0fc7cbd7.png)
Find the spreadsheet containing the mailing list, select it and click Open
![](https://ppm.smu.ca/TDPortal/Images/Viewer?fileName=1168be37-3215-4cfc-9b32-da306d410b14.png)
If there are multiple sheets inside the file, select the one containing the list and click OK. Otherwise, simply click OK.
![](https://ppm.smu.ca/TDPortal/Images/Viewer?fileName=46a25d56-916b-499a-9c95-0e53a6edfa88.png)
If there are multiple columns with data inside the spreadsheet, you may need to specify which column contains email addresses.
Your Recipient field should now show the number 1, meaning the list has been loaded and you are ready to send messages starting with recipient number one. If you click on the “Last” button the Recipient value should correspond the number of email addresses in the spreadsheet.
![](https://ppm.smu.ca/TDPortal/Images/Viewer?fileName=60990728-1a78-40c6-ab68-9b71834a5ce2.png)
Make sure the recipient field shows number 1, then click on Finish and Merge >> Send Email Messages
![](https://ppm.smu.ca/TDPortal/Images/Viewer?fileName=120a945e-934a-4b70-beeb-49e726a005c2.png)
Specify which spreadsheet column contains email addresses or accept the default, type in your subject, and click OK.
![](https://ppm.smu.ca/TDPortal/Images/Viewer?fileName=c21f6178-5761-462f-b1e8-75ff90ed0cf3.png)
Messages will be sent one by one to all recipients in the list. Both Outlook and Word should remain open until all messages are sent. You can monitor the progress in Outlook’s Sent folder. When Outlook’s Outbox reaches zero, the process is complete and the Word document can be closed.