Technology

Mail Merge

Last modified 1/9/2025

Mail merge is used to create a batch of documents that are personalized for each recipient.

The article information below tells you how to complete a mail merge once you have your document ready and use your mail merge documents with a shared mailbox. 

Note:

The following instructions require the desktop applications of Microsoft Word and Outlook.

  • How to Complete a Mail Merge

  1. Open a new document in Microsoft Word
  2. Select the Mailings tab from the top ribbon
  3. Choose the Select Recipients button. This will allow you to choose the list of people you want to send your document to. You can type a new list, use an existing one, or select Outlook Contacts. (Figure 1)
    Figure 1:

  4.   Select a List Option
    1. Create a New List 
      1. Select Type a New List... from the Select Recipients dropdown.  (Figure 2)
      2. Add as much information as desired for the recipients
      3. Email addresses in the last column must be filled out for each recipient. 
      4. Once all desired fields are completed, select OK
      5. Name your file, and select the desired location to save your file from the pop-up.
      6. Newly created lists are saved as Microsoft Office Address List (*.mdb)
        Figure 2:

    2. Use or View an Existing List
      1. Select Use an Existing List... from the Select Recipients dropdown (Figure 2) 
      2. Select the list you would like to use or view from the pop-up
        1. You can use a variety of file formats including .mdb, .cvs, and Excel files. 
        2. Once the file is selected, the pop-up will disappear
      3. Select  the Edit Recipient List button in the top toolbar (Figure 3) 
      4. A pop-up will display the contents of the list.
        Figure 3: 

  5. Compose the contents of the message within the Word document 
  6. If desired, use the Insert Merge Field option from the top ribbon. (This tool allows messages to be tailored to individual recipients based on t he fields selected.)
  7. Select Start Mail Merge from the top ribbon
  8. Select  E-mail Messages from the drop down (Figure 4) 
    Figure 4: 

  9. Select Finish & Merge from the top ribbon
  10. Select Send Email Messages... from the drop down (Figure 5)
    Figure 5:
     
  11. From the pop-up (Figure 6)
    1. Select the appropriate To field
    2. Fill out the Subject Line
    3. Keep the mail format as HTML
    4. Select OK
  12. Word will send the recipient list information to Outlook. Messages will be sent from the default sender.
    Figure 6: 

    Note:

    If you intend to send messages as a Shared Mailbox, make sure that Outlook as been configured wit the Shared Mailbox ass the default sender.


Adding a Shared Mailbox for Use with Mail Merge

  • Windows (Old Outlook)

To add a shared mailbox in Outlook, do the following:

  1. Open Outlook.
  2. Click File.
  3. Click Info on the left.
  4. Click the Account Settings button and select Account Settings.
  5. Select your Microsoft Exchange account.
  6. Click the Change button at the top of the window (Figure 1).

    Figure 1:
    account settings, change
  7. Click More Settings.
  8. Click the Advanced tab.
  9. Click the Add button (Figure 2).

    Figure 2:
    advanced tab, Add
  10. Enter the name of the shared mailbox and click OK.
  11. Click Apply and then click OK.
  12. Click Next.
  13. Click Finish.
  14. Click Close.
  15. Click Mail on the left. The shared mailbox appears on the left side of the screen. Expand the mailbox to view its contents.

You have now added the shared mailbox to Outlook.

  • Windows (New Outlook)

  1. Open the New Outlook application
  2. With Outlook opened, hover your mouse over the Folder dropdown button and right-click it, then click Add shared folder or mailbox (See Figure 1).

    Figure 1:
  3. You will then need to enter the name or the email address of the person who has a shared folder.
  4. Press Add once you have entered the name of the shared mailbox (See Figure 2). The shared folder will now be added to your folder panel.

    Figure 2:


  • Mac

To add a shared mailbox in Outlook on a Mac, do the following:

1. Open the Outlook app on your Mac.

2. Navigate to the Outlook tab in the upper left hand corner of your Mac and choose Settings.

3. In the Settings menu, choose the Accounts icon to open the Account menu. (Figure 1).

Figure 1:

4. Navigate to the icon in the lower left corner of the menu and choose Open Shared Mailbox. (Figure 2).

Figure 2:

5. Start typing in the name of the shared mailbox in the search bar at the top. A list of mailboxes will populate, once you see the one you need, choose it and click Add in the lower right corner. Note: A permissions check will run to verify you have access to that shared mailbox. (Figure 3)

Figure 3: 

Once the permission check is complete the shared mailbox will be added to your Outlook.



  • Configuring Outlook to use Mail Merge with a Shared Mailbox

Shared Mailbox users can benefit from the use of Microsoft's Mail Merge feature. To send as the Shared Mailbox when using the mail merge feature, the Shared Mailbox must be set as the default email. Before following the steps below, make sure you've followed the steps in the accordion "Adding a Shared Mailbox for Use with Mail Merge

Note:

This change will need to be reversed after the mail merge is completed, if the user wants their individual account to be the default for normal email account use 

  1. Open the Outlook desktop application
  2. Select File
  3. Select Options (Figure 1)
    Figure 1:

  4. Select Mail 
  5. Scroll down to the Send Messages section. 
  6. Check the box in front of "Always use the default account when composing new messages."
  7. Click OK (Figure 2)
    Figure 2:

  8. Select the Account Settings button
  9. Select Account Settings (Figure 3)
    Figure 3:

  10. Select the Shared Mailbox
  11. Select Set as Default,  then select Done (Figure 4) 
    Figure 4:



How to Get Help

Technical assistance is available through the Illinois State University Technology Support Center at: