How to change email account while sending mail merge
When sending a mail merge using Microsoft Word or Excel, you may need to change the email account associated with the mail merge. Here are the steps to do so:
Method 1: Using Microsoft Word
- Open your Word document and go to the "Mailings" tab in the ribbon.
- Click on "Finish & Merge" and then select "Send Email" from the dropdown menu.
- In the "Send Email" dialog box, click on the "Account" dropdown menu and select "Manage Accounts" from the list.
- In the "Account Settings" dialog box, click on the "Email Accounts" button.
- Select the email account you want to use from the list and click "OK".
- Go back to the "Send Email" dialog box and click "OK" to send the mail merge.
Method 2: Using Microsoft Excel
- Open your Excel spreadsheet and go to the "Data" tab in the ribbon.
- Click on "From Address" and select "Edit" from the dropdown menu.
- In the "From Address" dialog box, click on the "Account" dropdown menu and select "Manage Accounts" from the list.
- In the "Account Settings" dialog box, click on the "Email Accounts" button.
- Select the email account you want to use from the list and click "OK".
- Go back to the "From Address" dialog box and click "OK" to send the mail merge.
Method 3: Using Microsoft Outlook
- Open your Outlook email client and go to the "File" menu.
- Click on "Account Settings" and select "Account Settings" from the dropdown menu.
- In the "Account Settings" dialog box, click on the "Email" tab.
- Select the email account you want to use from the list and click "OK".
- Go back to your Word document or Excel spreadsheet and try sending the mail merge again.
Tips:
- Make sure you have the correct email account selected in your email client (Outlook, Gmail, Yahoo, etc.) before trying to send the mail merge.
- If you are using a Gmail account, you may need to enable "Less secure app access" in your Google Account settings to allow mail merge to work.
- If you are using a Microsoft 365 account, you may need to enable "Two-factor authentication" and generate an app password to use with your mail merge.