Email Merge from Excel: Steps, Setup, and Safer Sending

How-to basics · Updated November 22, 2026

Yes. To send personalized emails from an Excel list, prepare one row per recipient in Excel, then use Word’s Mailings > Start Mail Merge > E-mail Messages and connect the document to the workbook. Complete the message in Word and choose Mailings > Finish & Merge > Send E-mail Messages; Word sends each recipient a separate email through a configured email program, commonly classic Outlook for Windows.

What an email merge does

An email merge combines a message template with recipient data. Excel supplies information such as email addresses, names, appointment dates, or order numbers. Word inserts selected values into the message and creates a separate email for each matching row. For example, a community group could address each recipient by first name and include that person’s registration date without composing every message individually.

Excel is the data source, not the tool that sends the messages. Word handles the merge, and an email application or service sends the resulting emails. A basic merge is useful for notices, invitations, reminders, and other legitimate one-to-one communications. It is not the same as sending one message with a long list of people in the To or Cc field.

Prepare the Excel recipient list

Give the worksheet a simple, consistent structure before connecting it to Word. Put descriptive column names in the first row, with one recipient per subsequent row. Avoid merged cells, blank header names, and extra title rows above the headings; these can make it harder to identify or select the correct fields during the merge.

  • Use a column such as Email for each recipient’s complete email address. Check for missing addresses, extra spaces, and obvious typing errors.
  • Use separate columns for values you may want to insert, such as FirstName, LastName, Organization, and EventDate. Clear, unique headers are easier to recognize as merge fields.
  • Keep each row’s information together and avoid blank rows within the recipient list. Remove test or excluded contacts, or use Word’s recipient filters to leave them out.
  • Save the workbook in a location you can access again. Close it before connecting from Word if the file is open or locked by another process.

Use actual Excel dates for date fields rather than text that only looks like a date. If Word displays a date in an unwanted format, adjust the merge field’s number format in Word or prepare a separate, consistently formatted text column in Excel. Phone numbers and postal codes with leading zeroes should be stored as text if Excel would otherwise remove those zeroes. Keep a backup of the source workbook, especially if it contains the only copy of the contact data.

Connect Word to the workbook

These steps are for Word and Excel for Microsoft 365 on Windows. First open Word and create a blank document. On the Mailings tab, select Start Mail Merge > E-mail Messages. Then select Select Recipients > Use an Existing List, browse to the Excel workbook, and choose the worksheet or named range containing the list. If Word asks whether the first row contains column headings, confirm that it does when your first row contains the field names.

Next, select Edit Recipient List if you need to review the records, uncheck recipients who should not receive the message, or apply a filter. Place the cursor where personalized text should appear, then use Mailings > Insert Merge Field to choose a column. For example, write Hello, insert the FirstName field, and add a comma. The document may show a field marker rather than a real name until you select Mailings > Preview Results.

Write the rest of the message in Word and preview several records, including any with long names, blank optional fields, or unusual dates. When the content is ready, choose Mailings > Finish & Merge > Send E-mail Messages. In the dialog, select the email-address column in the To list, enter a subject line, and choose a mail format such as HTML. Choose All only if every listed recipient should receive the message; otherwise select the appropriate record range. Confirm the dialog to send.

Make the message readable and personal

Keep the body concise and make the purpose clear near the beginning. A practical example might say: Hello, followed by the FirstName merge field, then a sentence explaining that the recipient’s appointment is on the EventDate field. Use Preview Results to check that the inserted text reads naturally. A blank first name can produce an awkward greeting, so either correct missing data, create a generic greeting for those records, or exclude them.

Word’s email merge is best suited to straightforward message layouts. Basic text and common formatting are usually more dependable than elaborate designs. If you use HTML formatting, inspect the message in a real email account before sending the full list; mail clients can display fonts, spacing, images, and links differently. A mail merge does not automatically make every linked image appear inline, and recipients’ email settings may block images. Avoid relying on decorative formatting to convey essential information.

Test delivery before sending the full list

Do not treat Preview Results as a delivery test: it checks the merged content in Word, not how the email arrives or whether the sending account can deliver it. Make a small test workbook with a few addresses you control, or use a small, appropriate test group. Confirm the recipient, subject, greeting, links, date formatting, and message appearance in the destination inbox. Check junk or spam folders if a test message does not appear.

For a larger list, consider sending in manageable batches rather than assuming a single large merge will be accepted. Email providers and organizations set their own sending limits, and those limits can depend on the account, recipient count, and time period. A merge may also be interrupted by a connection problem or a service limit. Keep track of which records were sent, and do not blindly repeat the full merge after an interruption: some people may already have received it.

Outlook, Mac, and web-version differences

On Windows, Word’s email merge traditionally sends through a configured MAPI-compatible desktop email program. For Microsoft 365 users, that commonly means classic Outlook for Windows with an account set up. New Outlook for Windows does not provide the same MAPI support used by Word’s traditional email merge, so it may not work as the sending application. If the send command fails or does nothing, check whether classic Outlook is installed and configured, and whether it is the default email application. Your organization’s IT team may control these settings.

Word for Mac has its own Mailings interface and account requirements; the labels and available choices can differ from Windows. Check that the installed Word and email applications support the workflow, configure the sending account, and run a small test before using a real list. Excel for the web can store and edit the workbook, but it does not replace desktop Word’s mail-merge sending workflow. Open the file in the desktop apps for the steps described here.

Common problems and what to check

  • The email field is missing: Confirm that the correct worksheet or range was selected and that the first row contains a clear heading. Reconnect to the workbook if the source list changed after Word selected it.
  • Names or dates look wrong: Check the underlying Excel values and the field’s formatting. Preview records with different values instead of checking only the first row.
  • Messages do not send: Verify that a supported desktop email program and account are configured, that the sending account is online, and that your organization allows the action. Try a small test rather than resending the entire list.
  • Some people are omitted: Review the recipient list, filters, and selected record range. Check for blank email cells and confirm that the chosen To field is the address column.
  • Recipients see a plain or messy layout: Simplify the formatting, select an appropriate mail format, and test in the email clients your audience commonly uses.

Privacy, limits, and alternatives

A standard email merge creates separate messages, which helps avoid exposing a list of recipients to one another in a shared To or Cc line. It does not, by itself, guarantee privacy or make a mailing appropriate. Send only to people who should receive the communication, protect the workbook because it may contain personal information, and follow your organization’s policies and applicable email rules. Double-check the selected audience and the content before sending; a wrong filter or address column can disclose information or send an unintended message.

For a modest list and occasional personalized notices, Word and Excel may be sufficient if the required desktop software is already available. A dedicated email-marketing platform or customer relationship management system is often a better fit for recurring campaigns, subscription management, automated opt-outs, delivery reporting, templates, and larger audiences. Features, pricing, and sending limits vary by provider, so compare the service against your actual needs. Do not assume that buying Microsoft 365 removes the sending limits imposed by an email account or organization.

Frequently Asked Questions

Can I send an email merge directly from Excel? Not with the standard Word mail-merge workflow. Excel provides the recipient data, while Word creates the personalized messages and a compatible email application sends them. Other automation tools may use Excel data, but they are separate workflows.

Can I use Gmail instead of Outlook? Word’s traditional Windows email merge relies on a compatible desktop email program and is commonly used with classic Outlook. A Gmail account in a browser is not a direct substitute for that desktop sending connection. For Gmail-based campaigns, use a workflow or service that explicitly supports Gmail and check its sending requirements.

Does each recipient see the other email addresses? In a normal Word email merge, each recipient receives an individual message addressed using the selected To field, rather than one message showing all recipients in To or Cc. Still, test the workflow and inspect the delivered message before sending sensitive or important communications.

Can I include an attachment for each recipient? The standard email-merge dialog is not a convenient way to attach a different file to each person based on an Excel row. If each recipient needs an individualized attachment, use a purpose-built, approved tool or workflow, and test it carefully. For a shared document, a secure link may be more manageable than many attachments.

How many emails can I send at once? There is no single limit that applies to every merge. The sending account, email provider, organization settings, and sending rate can all affect delivery. Check the rules for the account you will use, and split a large legitimate mailing into controlled batches if needed.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.