How to change sender email in mail merge

In a mail merge, you can change the sender email address by modifying the From field in the mail merge document. Here are the steps:

Method 1: Using Microsoft Word

  1. Open your mail merge document in Microsoft Word.
  2. Go to the "Mailings" tab in the ribbon.
  3. Click on "Select Recipients" and then "Use an Existing List" to select your recipient list.
  4. Click on "Finish & Merge" to merge the document.
  5. In the "Merge to E-mail" dialog box, click on the "Options" button.
  6. In the "E-mail Options" dialog box, click on the "From" field and enter the new sender email address.
  7. Click "OK" to close the dialog box and then click "OK" again to merge the document.

Method 2: Using Microsoft Outlook

  1. Open your mail merge document in Microsoft Word.
  2. Go to the "Mailings" tab in the ribbon.
  3. Click on "Select Recipients" and then "Use an Existing List" to select your recipient list.
  4. Click on "Finish & Merge" to merge the document.
  5. In the "Merge to E-mail" dialog box, click on the "Options" button.
  6. In the "E-mail Options" dialog box, click on the "From" field and select "Outlook" as the email client.
  7. Enter the new sender email address and password in the respective fields.
  8. Click "OK" to close the dialog box and then click "OK" again to merge the document.

Method 3: Using VBA Macro

  1. Open your mail merge document in Microsoft Word.
  2. Press "Alt + F11" to open the Visual Basic Editor.
  3. In the Editor, insert a new module by clicking "Insert" > "Module".
  4. Paste the following code into the module:
    Sub ChangeSenderEmail()
 Dim doc As Document
 Set doc = ActiveDocument
 doc.MailMerge.OpenRecordset
 doc.MailMerge.From = "[email protected]"
End Sub
  5. Replace "[email protected]" with the new sender email address.
  6. Click "Run" > "ChangeSenderEmail" to execute the macro.
  7. The sender email address will be updated in the mail merge document.

Note: The above methods assume that you are using Microsoft Word 2010 or later version. If you are using an earlier version, the steps may vary slightly.