Technology

Mail Merge

Last modified 2/20/2024


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

Many Shared Mailbox users benefit from the use of Microsoft’s mail merge feature. To use the mail merge feature, the Shared Mailbox must be set as the default email. Follow the steps below to add a shared mailbox to your Outlook Application. 

  1. Open the Outlook desktop application
  2. Select File
  3. Select Info from the left hand menu
  4. Select the Account Settings button
  5. Select Account Settings (Figure 1)
    Figure 1:

  6. Select New (Figure 2)
    Figure 2: 

  7. When prompted, type in the email address for the shared mailboxes (Figure 3)
    Figure 3: 

  8. If prompted Login through Central Login and verify with MFA
  9. A pop-up will appear confirming the account was added successfully and explaining that Outlook needs to be restarted. (Figure 4) 
    Figure 4:

  10. Select Done
  11. Restart the Outlook application
  12. The newly added mailbox should appear in the left hand menu along with its default folder structure. (Figure 5)
    Figure 5: 


  • 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: