If you have a need to mail merge from a shared mailbox, ensure that you have the following as well:
- Permissions to the Shared Mailbox in Question (full access)
- Outlook 2013 (PC) or 2016 (Mac), or OWA
Procedure:
- First, go to Adding a Second Profile in Outlook for O365 - Powered by Kayako Help Desk Software (osu.edu) to set your shared mailbox up as a second profile, if you haven’t already done this
- Open Outlook to the appropriate profile
- Put Outlook in Offline Mode
- Go to the Send/Receive tab and select the Work Offline button
- If you are using Office 2016 for the Mac, go to the Tools tab and toggle the Online/Offline button
- Go to the Send/Receive tab and select the Work Offline button
- Open the document you want to send via MailMerge
- Go to the Mailings tab
- Click Select Recipients and go to “Use Existing List”
- Use the dialog box to navigate to and open the data spreadsheet
- Select the appropriate table in the text dialog box
- If necessary, select Edit Recipient List and de-select all unwanted data
- Select Finish and Merge
- Go to Send E-Mail Messages
- In the “Merge to E-mail” dialog box that comes up, verify that the “To:” field and the “Subject line” field show the correct fields. Then verify that the mail format is HTML. Click OK.
- The emails will then propagate in your Outbox in Outlook
- If you want to, you can open them up and manually edit any information in. For example, in the “CC” field you could add additional reciepents on an adhoc basis.
- When you are sure that the the emails are correct, turn Outlook back into Online mode and the messages will be sent