Send a Mail Merge from a Shared Mailbox

Summary

Learn how to send personalized email messages from a departmental shared mailbox using Microsoft Word and classic Outlook for Windows.

Body

Send a Mail Merge from a Shared Mailbox

Overview

Microsoft Word's Mail Merge feature allows you to send personalized email messages to multiple recipients using information from an Excel spreadsheet.

If you need these messages to appear from a Cedar Crest College departmental shared mailbox rather than your personal email address, additional Outlook configuration is required.

Important: This procedure requires Microsoft Word and classic Outlook for Windows. It is not supported through the traditional mail merge workflow in New Outlook or Outlook on the web.

Important: These instructions are intended for Microsoft 365 shared mailboxes used by College departments. They do not apply to regular employee mailboxes that have been shared with another person through Outlook delegation. Mail merge from a delegated user mailbox may require a different configuration.

Before You Begin

You will need:

  • Microsoft Word and classic Outlook installed on a Windows computer.
  • Access to the departmental shared mailbox.
  • Send As permission for the shared mailbox.
  • An Excel spreadsheet containing recipient email addresses and any information used to personalize messages.
  • An Outlook profile or account configuration that supports sending mail merges from the shared mailbox.

Note: Having Read and Manage access to a shared mailbox does not automatically grant Send As permission.

Shared Mailbox Setup

Mail Merge sends messages using the default sending account configured in classic Outlook.

Simply having a shared mailbox displayed in Outlook does not guarantee that the messages will be sent from that address.

If you have not previously configured your shared mailbox for Mail Merge, submit an IT Support Request for assistance.

IT can verify your permissions and help configure the appropriate Outlook profile or sending account.

Security reminder: Do not attempt to sign in directly using a shared mailbox password. Shared mailboxes should be accessed through your authorized College account.

Step 1 – Prepare Your Recipient List

  1. Open Microsoft Excel.
  2. Create or review your recipient spreadsheet.
  3. Make sure the first row contains column headings, such as Email, FirstName, and LastName.
  4. Verify that the email addresses are correct.
  5. Remove duplicate or unwanted recipients.
  6. Save and close the spreadsheet.

Step 2 – Open Classic Outlook

  1. Open classic Outlook for Windows using the profile configured for your shared mailbox.
  2. Verify that the shared mailbox is configured as the default sending account for the mail merge.
  3. Create a new test message and confirm that the From address is the intended shared mailbox.
  4. Close the test message without sending it.

Important: If you cannot verify the shared mailbox as the default sender, do not proceed with the mail merge. Contact IT for assistance.

Step 3 – Work Offline (Optional)

Working offline allows you to review generated messages in the Outlook Outbox before sending them.

  1. In classic Outlook, select the Send/Receive tab.
  2. Select Work Offline.
  3. Verify that Outlook indicates it is working offline.

Note: Work Offline is an additional review option, not a guarantee that messages cannot be transmitted. For the safest initial test, perform a small mail merge using only your own email address before sending to the full recipient list.

Step 4 – Create Your Mail Merge in Word

  1. Open Microsoft Word.
  2. Create or open the document containing your email message.
  3. Select the Mailings tab.
  4. Select Start Mail Merge > E-mail Messages.
  5. Select Select Recipients > Use an Existing List.
  6. Browse to your Excel spreadsheet and select it.
  7. Choose the appropriate worksheet or table.
  8. Select Edit Recipient List if you need to exclude recipients.
  9. Place your cursor where personalized information should appear.
  10. Select Insert Merge Field and choose the appropriate field.
  11. Repeat as needed to personalize the message.
  12. Select Preview Results to verify that the information appears correctly.

Step 5 – Complete the Mail Merge

  1. In Word, select Finish & Merge > Send E-mail Messages.
  2. In the dialog box, configure the following:
    • To: Select the column containing recipient email addresses.
    • Subject line: Enter the subject of your message.
    • Mail format: Select HTML.
    • Send records: Choose the appropriate records.
  3. Review your selections carefully.
  4. Select OK.

If Outlook is working offline, the generated messages should appear in its Outbox.

Step 6 – Review and Send Messages

If you used Work Offline:

  1. Return to classic Outlook.
  2. Open the Outbox.
  3. Review the generated messages.
  4. Verify the recipient addresses, subject lines, personalized content, and sender account.
  5. Confirm that the messages are ready to send.
  6. Select Send/Receive > Work Offline to reconnect Outlook.
  7. Allow Outlook to send the queued messages.

Check the Sent Items folder associated with the shared mailbox or the sending account to confirm successful delivery.

Important: If you discover an error, do not reconnect Outlook until the affected messages have been removed or corrected.

Step 7 – Restore Your Normal Outlook Settings

If you temporarily changed your default sending account or Outlook profile:

  1. Return to the Outlook account or profile settings.
  2. Restore your personal Cedar Crest College account as the default sender.
  3. Restart Outlook if necessary.
  4. Verify that new messages are being created from your normal email account.

This helps prevent future messages from accidentally being sent from the departmental shared mailbox.

Troubleshooting

Messages Are Sending From My Personal Email Address

Word Mail Merge uses Outlook's default sending account.

Verify that the shared mailbox is correctly configured for Mail Merge. If necessary, request assistance from IT.

I Receive a Permission Error

You may not have Send As permission for the shared mailbox.

Submit an IT Support Request so your permissions can be reviewed.

The Mail Merge Option Is Missing or Not Working

Confirm that you are using desktop Microsoft Word and classic Outlook for Windows.

The traditional Word Mail Merge process is not available through New Outlook or Outlook on the web.

Messages Are Stuck in the Outbox

  • Check whether Outlook is still in Work Offline mode.
  • Verify that your internet connection is working.
  • Confirm that Outlook is connected to Microsoft 365.
  • Check for any sending or permission errors.

Some Recipients Did Not Receive Their Messages

Microsoft 365 has sending limits and anti-spam protections that may affect large mail merges.

Review any nondelivery notifications. For large departmental communications, contact IT before attempting to resend messages in bulk.

Additional Resources

Need Additional Assistance?

If you need help configuring a shared mailbox for Mail Merge or encounter an error, submit an IT Support Request.

Include the shared mailbox address, the version of Outlook you are using, and any error messages. Do not include passwords or verification codes.

Details

Details

Article ID: 66609
Created
Fri 11/2/18 3:49 PM
Modified
Mon 10/26/26 4:11 PM