Send & Receive Issues

How to Send 500 Personalized Emails from Excel with Outlook

Elise Williams Sep 28, 2026 870 views

Question details

The user needs to send a large batch of personalized emails (e.g., 500 recipients) using contact data stored in an Excel spreadsheet and Outlook as the mail client, ensuring each recipient only sees their own email address.

How to Send 500 Personalized Emails from Excel Using Outlook

Product: Microsoft Excel
Device & OS: not provided
Scenario: Executing a mass emailing campaign or sending personalized newsletters to a large recipient list without exposing email addresses.
Observed behavior: Requires a secure and automated method to extract names and email addresses from an Excel workbook, merge them into individual email messages, and dispatch them via Outlook.

Before you start

Ensure Outlook is configured as your computer's default email client and verify with your email provider that sending 500 emails at once does not exceed your daily mass-mailing limits to avoid being flagged as spam.

Solution 1Recommended

Use Word's Mail Merge Feature with Excel and Outlook

Utilize the built-in Mail Merge tool in Microsoft Word to link your Excel contact list and automatically send individual, personalized emails through Outlook.

Mail Merge bridges Excel, Word, and Outlook. By using Word as the message editor, you can pull data directly from Excel columns to personalize the greeting and body of each email, then route the finished messages directly through Outlook as separate, private emails.

Prepare the Excel recipient list

Open a new Excel workbook and create header rows for your data (e.g., First Name, Last Name, Email Address). Fill in the 500 contacts, ensure there are no blank rows, and save the file.

Start the Mail Merge in Word

Open Microsoft Word, create a blank document, and navigate to the 'Mailings' tab. Click 'Start Mail Merge' and select 'Email Messages' from the dropdown menu.

Connect the Excel workbook

Still on the 'Mailings' tab, click 'Select Recipients', choose 'Use an Existing List', and browse your computer to locate and open the Excel file you saved in step one.

Draft the email and insert merge fields

Type out your email message. To personalize it, place your cursor where you want a name to appear, click 'Insert Merge Field' on the ribbon, and select the corresponding column header (e.g., First Name).

Send the emails through Outlook

Click 'Finish & Merge' and select 'Send Email Messages'. In the dialog box, choose the column containing the email addresses for the 'To' field, type your desired subject line, select 'HTML' format, and click 'OK' to begin sending.

Use Word's Mail Merge Feature with Excel and Outlook

Mass-Mailing Limits: Microsoft 365 Exchange accounts typically have a sending limit (e.g., 10,000 recipients per day or 30 messages per minute). Free providers like Gmail or Yahoo may restrict sending to 500 emails per day.

WPS Office Mail Merge

Send Mass Emails Seamlessly with WPS Office

WPS Office includes a powerful Mail Merge tool in WPS Writer that easily connects to your WPS Spreadsheet data, allowing you to send out personalized mass emails efficiently using your system's default email client.

1. Open Data Source: Launch WPS Writer, navigate to the 'References' or 'Mailings' tab, click 'Open Data Source', and select your WPS Spreadsheet containing the email list.
2. Insert Merge Fields: Draft your email content and use the 'Insert Merge Field' button to add personalized placeholders like names or company details.
3. Merge to Email: Click 'Merge to Email', specify the column containing recipient email addresses, type a subject line, and execute the merge to send via your default mail client.

Fully compatible with Microsoft Excel (.xlsx) and Word (.docx) formatsBuilt-in Mail Merge capabilities for streamlined mass emailingFamiliar, tabbed user interface for a zero-learning-curve transitionLightweight software footprint that runs smoothly on older devices

Frequently Asked Questions

Will recipients see the other 499 email addresses?

No. The Mail Merge feature generates a completely separate email for each row in your Excel spreadsheet. Recipients will only see their own email address in the 'To' field, ensuring total privacy.

Can I attach different PDF files to each personalized email during a mail merge?

The standard Mail Merge feature in Word and Outlook does not natively support adding unique attachments to each email. You would need to use a third-party add-in for Outlook or a custom VBA macro to achieve personalized attachments.

What happens if Outlook is closed when I finish the mail merge?

If Outlook is closed, the generated emails will queue in your Outlook 'Outbox' folder. They will remain there and only begin sending once you launch the Outlook application.

How do I filter out certain contacts from the Excel list before sending?

After selecting your recipient list in Word, click on 'Edit Recipient List' in the Mailings ribbon. A dialog box will appear where you can uncheck specific individuals or use the filter options to exclude contacts based on certain column criteria.

Outlook & Email Problems