Mail merge in Outlook works by connecting your email to a data source — usually a spreadsheet or contact list — so you can send personalized messages to many people at once without typing each one individually.

The process has three parts: prepare your data in a spreadsheet, set up the merge fields in your email template, and run the merge through Outlook. Outlook itself does not have a built-in mail merge feature the way Word does, so you will use Word as the engine and Outlook as the sending tool. This takes about 15 to 30 minutes to set up the first time, and then you can reuse the same template for future sends.

Key Takeaways

  • Mail merge requires three things: a clean spreadsheet with one column per data field, a Word document with merge fields marked, and Outlook to send the finished emails.
  • Your spreadsheet must have headers in the first row (like "First Name", "Email", "Company") and one person per row, with no blank rows or extra formatting.
  • You create the merge in Word, not Outlook, by inserting merge fields where you want personalized data to appear in your message.
  • After the merge completes in Word, you send the emails through Outlook, which lets you review each one before it goes out.

Prepare your spreadsheet with the right structure

Start with a spreadsheet in Excel, Google Sheets, or another program that saves as .xlsx or .csv. The first row must contain headers — the names of your data fields. Common headers are "First Name", "Last Name", "Email", "Company", "Title", or anything else you plan to personalize. Each column holds one type of information, and each row below the header is one person.

Clean your data before you start the merge. Remove any blank rows in the middle of your list, delete extra spaces before or after names, and make sure every email address is valid. If you have 500 rows and row 247 is blank, the merge will stop or skip that row and confuse your count. Save the file and remember where it is — you will need the full file path in a few steps.

Create your email template in Word

Open a new Word document. This is where you write the email body — the message that will be personalized and sent. Type out your message as you want it to appear, and leave placeholders where you want data from your spreadsheet to go. For example: "Dear <>, thank you for your interest in <>."

Do not include the email subject line or recipient address in this document — you will add those in Outlook after the merge. Just write the body of the email. Keep the tone and length reasonable; very long merged emails are harder to personalize well and more likely to land in spam folders.

Insert merge fields into your Word template

In Word, go to the Mailings tab at the top. Click Select Recipients and choose Use an Existing List. Navigate to your spreadsheet file and open it. Word will show you a preview of your data to confirm it loaded correctly.

Now click in your document where you want the first piece of personalized data to appear. Go to Mailings > Insert Merge Field and select the column header you want — for example, "First Name". Word will insert <> into your document. Repeat this for every field you want to personalize. Your template might look like: "Dear <> <>, we have an opening at <> for a <> role."</p> <h2>Preview and finish the merge in Word</h2> <p>Before you send anything, preview how the merge will look. In the <strong>Mailings</strong> tab, click <strong>Preview Results</strong>. Word will show you the first merged email with real data from your spreadsheet. Use the arrow buttons to scroll through a few examples and check that names, companies, and other details are in the right places and spelled correctly.</p> <p>If something looks wrong — a name is misspelled in your spreadsheet, a field is in the wrong order, or a merge field is missing — go back and fix it now. It is much faster to correct your spreadsheet or template before you merge than to fix 200 emails after.</p> <h2>Complete the merge and send through Outlook</h2> <p>In the <strong>Mailings</strong> tab, click <strong>Finish & Merge</strong> and select <strong>Send Email Messages</strong>. Word will ask you which field contains the email addresses — select the column header that holds your recipient emails (usually "Email"). Then choose whether to send to all recipients or a specific range, and click OK.</p> <p>A dialog box will appear asking you to fill in the subject line and choose your Outlook account. Type your subject line here — this is the only place to set it for all merged emails. Select the Outlook account you want to send from, then click OK. Word will create individual emails in your Outlook Drafts folder, one for each person on your list.</p> <h2>Review and send your merged emails from Outlook</h2> <p>Open Outlook and go to your Drafts folder. You will see all the merged emails stacked there, one per recipient. Click on the first one and read it to make sure the personalization looks right and the subject line is what you intended. If everything looks good, you can send them one at a time, or select all of them and send as a batch.</p> <p>Outlook will not send merged emails automatically — you control when they go out. This is a safety feature; it gives you a chance to catch mistakes before they reach 200 inboxes. If you spot an error after reviewing a few, you can delete the drafts, fix your template or data, and run the merge again.</p> <h2>Frequently Asked Questions</h2> <h3>Can I use Outlook's contact list instead of a spreadsheet?</h3> <p>Not directly for mail merge. You can export your Outlook contacts as a .csv file, then use that file as your data source in Word. Go to Outlook, select your contacts, and use File > Open & Export > Import/Export to save them as a spreadsheet. Then follow the merge steps above with that exported file.</p> <h3>What if my spreadsheet has 5,000 people and I only want to send to 500?</h3> <p>Filter your spreadsheet before you start the merge. Delete the rows you do not want to include, or create a new sheet with only the recipients you need. You can also use Word's merge settings to send to a specific range of rows — for example, rows 1 to 500 — instead of the whole list.</p> <h3>Can I schedule merged emails to send later instead of right away?</h3> <p>Word creates the emails in Outlook's Drafts folder, so they do not send until you tell them to. You can leave them there and send them whenever you want. Outlook's delay delivery feature works on individual emails, so if you need to send 200 emails at a specific time, you would need to set the delay on each one or use a third-party tool designed for scheduled sends.</p> <h3>What happens if an email address in my spreadsheet is wrong or missing?</h3> <p>Word will still create a draft email for that row, but it will have a blank or invalid recipient field. When you review your drafts in Outlook, you will see the problem when ready. Delete those drafts or fix the email address in Outlook before sending. This is why reviewing your data before the merge saves time.</p> <h3>Can I add attachments to merged emails?</h3> <p>Yes, but all recipients get the same attachment. Add the file to your Word template before you merge — insert it as you normally would in an email. If different people need different attachments, you would need to use a mail merge tool beyond Word and Outlook, or send the emails in smaller groups with different attachments.</p>