logo
search
Send & Receive Issues

How to Choose the Sending Account for an Outlook Mail Merge

Muhammad TalhaMuhammad Talha Sep 30, 2026 869 views

Question details

The user needs to specify which Outlook Exchange account is used to send emails during a Microsoft Word mail merge process.

How to Choose the Sending Account for an Outlook Mail Merge
Product
Microsoft Word and Outlook
Device & OS
not provided
Scenario
Performing an email mail merge in Word with multiple Exchange accounts configured in the Outlook application.
Observed behavior
The mail merge automatically uses the wrong Outlook account to send the merged messages instead of the intended sender account.
Before you start

Ensure all your email accounts are properly configured and fully synced in Outlook before adjusting the default settings or starting the mail merge process.

Solution 1Recommended

Set Your Preferred Account as the Default in Outlook Settings

Change Outlook's default account and mail composition settings to force the mail merge process to use the correct email address.

When multiple accounts are configured in Outlook, Word mail merge relies on Outlook's default account settings. By explicitly defining the default account and enforcing it for all new messages, you can route the mail merge through the correct address.

1
Access Account Settings

In Outlook, navigate to the 'File' tab in the top ribbon, click on 'Account Settings', and then select 'Account Settings' from the drop-down menu.

2
Set the Default Sending Account

In the Email tab, click on the desired email account you want to use for the mail merge, and click the 'Set as Default' button. A checkmark will appear next to it.

3
Modify Mail Composition Options

Close the Account Settings window and go to 'File' > 'Options' > 'Mail'. Scroll down until you find the 'Send messages' section.

4
Force Default Account Usage

Check the box that says 'Always use the default account when composing new messages'. Click 'OK' to save your changes, and then start your Word mail merge again.

Set Your Preferred Account as the Default in Outlook Settings
Configuration Complete: Word will now route all mail merge emails through the newly selected default Outlook account.
Streamline Your Workflow

Create and Send Mail Merges Easily with WPS Office

WPS Writer offers a built-in, user-friendly Mail Merge feature that seamlessly integrates with your data sources, making it incredibly easy to send personalized bulk emails without complex Outlook configurations.

  1. 1. Prepare Data Source: Create a spreadsheet in WPS Spreadsheet containing your contacts' names, email addresses, and other personalized data.
  2. 2. Start Mail Merge: Open your document in WPS Writer, navigate to the 'References' tab, and click the 'Mail Merge' button.
  3. 3. Insert Merge Fields: Click 'Open Data Source' to link your spreadsheet, then use 'Insert Merge Field' to place personalized data into your document.
  4. 4. Send Emails: Click 'Merge to E-mail', specify the email address column from your data source, add a subject line, and hit send.
Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formatsIntuitive Mail Merge wizard for step-by-step guidance on mass email campaignsLightweight application that runs smoothly on older devicesFree to use basic features for everyday office tasks and document formatting
microsoft office alternative - wps office

Frequently Asked Questions

Can I switch sending accounts without changing the default in Outlook?

During a standard Word mail merge, it will automatically use the default Outlook account. Changing the default setting in Outlook Options and forcing its use for new messages is the most reliable way to ensure emails are sent from the correct address.

Why are my mail merge emails stuck in the Outlook Outbox?

This usually happens if Outlook is set to 'Work Offline', the selected account lacks the proper sending permissions, or there is an authentication issue with the Exchange server. Ensure Outlook says 'Connected' at the bottom right of the window.

Can I use an alias or shared mailbox for a mail merge?

Yes, but you must add the shared mailbox as a distinct, separate account in your Outlook profile and set it as the default account before running the mail merge, rather than just having it mapped as an additional folder.

Does WPS Office support email mail merge features?

Yes, WPS Writer includes a comprehensive Mail Merge feature under the References tab. It allows you to link data from WPS Spreadsheets and send bulk personalized emails efficiently.