Turn spreadsheet rows into personalized letters, labels, envelopes, and emails, then scale beyond Outlook and Gmail caps.
by Isabella Torres · Last updated: 2026-09-30Mail merge with Excel lets you turn spreadsheet rows into personalized letters, labels, envelopes, and emails by linking your columns to a template in Word or Outlook. You prepare clean data in Excel, insert merge fields, preview the result, then finish the merge to print or send each personalized item automatically.
It is ideal for basic personalization, especially for small lists or one-off sends. As your list grows, though, Excel mail merge can become slow, error-prone, and limited by Gmail or Outlook sending caps, with no visibility into who opened or clicked. Use this guide to master Excel mail merge first, then see how mail merge in Mailsoftly runs the same workflow straight from your sheet, with a personal PDF for each row if you need one.
For a broader overview, you can also read our What is Mail Merge guide.
New here? Start with our primer on Email Marketing Fundamentals for the fundamentals, then come back to this guide.
Sending a mail merge to more than a few dozen people? Gmail and Outlook cap how many recipients you can reach in a day and show you nothing about opens or clicks. Mailsoftly sends personalized emails to your whole list with tracking, free up to 500 contacts and 2,000 emails a month with your Gmail, Outlook, Google Workspace or Microsoft 365 account, no credit card.
Start free with Mailsoftly →
Key Takeaways
Import your Excel sheet into Mailsoftly as it is and every row becomes a contact. Turn any column you need, like a shift, a due date or a store, into a field from that column’s own header, then write the email once and add the fields from Personalize. Set a fallback for anyone missing a detail, check each person’s copy, and send with your Gmail, Outlook, Google Workspace or Microsoft 365 account address. Every email is checked for spam and delivery before it goes out and carries an unsubscribe link. The two minute video below shows the whole mail merge, from importing the sheet to sending. The Starter plan is $15 a month (billed yearly) for 1,000 contacts and 10,000 emails, and lets you send from your own domain.
0:00 Mail merge from Excel, no Word or Outlook. Here is how to do a mail merge straight from an Excel sheet, with every email personalized, and no Word or Outlook. The usual way takes three programs.
0:10 Why not Excel, Word and Outlook? Excel holds the data, Word writes the letter, and Outlook on your computer sends it. There is no unsubscribe link and no delivery check. Here is the same job with just your sheet and Mailsoftly.
0:24 How do I import my Excel sheet? Start under Audience, and click Import Contacts. Drop in your Excel file, just as it is. Mailsoftly reads every row. Name the new list, and go to the next step.
0:40 How do I turn columns into merge fields? Every column in your sheet shows up here, with its own data. Names and email are matched for you. Shift is your own column, so turn it into a field, right from its header. Then do the same for Station. Any column can become a merge field.
0:56 How do I finish the import? Confirm these people agreed to hear from you, and start the import. Twelve volunteers, imported. Your sheet is now a list.
1:06 How do I send it from my own Gmail? From the list, compose an email, and pick plain text so it reads like a note from you. The volunteer list is already chosen. Send it from your own Gmail address. Give it a name for your own records, then a subject.
1:24 How do I personalize each email? Now the merge. Type Hi, open Personalize, and pick First name. Write your message, and where their time goes, pick Shift from the same menu. It becomes each person’s own time slot. Then pick Station. Write the rest once, and every volunteer gets their own shift and station.
1:46 What if a contact is missing a detail? Set a fallback for anyone missing a detail, so nobody ever reads a blank. Spam and delivery checks run before anything goes out.
1:56 How do I check each person’s copy? Now check each person’s copy. Madison is on the welcome desk, from nine to noon. Jacob is at the coffee bar, from noon to three.
2:08 Send it. Send it now. Every volunteer gets their own email, from your Gmail address, with an unsubscribe link built in. A mail merge from Excel, with no Word and no Outlook. Start free at mailsoftly.com.
Mail merge with Excel is worth it because it personalizes high volumes of communication in minutes instead of hours, while keeping formatting consistent across every recipient. Excel stores the data, the template controls the design, and the merge engine pairs them automatically. Here is what that delivers in practice.
Excel stores the data and Word writes the letter, but neither sends a different document to each person. That last step is where most of the manual work in a mail merge hides.
Read enough? Try Mailsoftly free with 500 contacts and 2,000 emails per month with your Gmail, Outlook, Google Workspace or Microsoft 365 account, no credit card.Start free with Mailsoftly →
Excel mail merge is great for personalization, but it has no sending engine, no analytics, and no compliance tooling of its own, so it leans on Gmail or Outlook for delivery. A dedicated platform keeps the same Excel list and removes those limits. The table below compares the two approaches side by side.
| Task | Excel + Word/Outlook | Mailsoftly |
|---|---|---|
| Importing data | Manual file linking to a worksheet | Upload Excel or CSV in one step |
| Personalization | Basic merge fields, IF rules in Word | Merge tags with fallbacks, IF and ELSE conditional text, in the subject and the body |
| Sending limits | Gmail or Outlook daily limits | Scales reliably with deliverability safeguards |
| Design | Plain text or basic HTML | Drag and drop email templates |
| Automation | None | Automated journeys and triggers |
| Analytics | Little to none | Opens, clicks, bounces, device and link-level stats |
| Compliance | Manual handling | Built-in unsubscribe and list hygiene |
| Per-person documents | One merged file to split and attach by hand | One PDF per recipient, attached or behind a secure link |
| Checking each copy | Preview Results in Word, one record at a time | Open any recipient’s exact email and PDF before sending |
| Scale past 500 recipients | Risky | Designed for it |
Prepare your Excel workbook by giving every column a clear header in row one, putting one complete recipient per row, and formatting dates and ZIP codes correctly before you link the file to Word. A clean workbook is the single foundation of a successful merge. Take the time to do the following.

Create a mail merge template in Word by opening a blank document, choosing a merge type on the Mailings tab, connecting it to your Excel file, then inserting merge fields where personalization belongs. This template can generate printed letters, envelopes, labels, or email messages sent through Outlook.

Dear «FirstName» «LastName», We look forward to seeing you on «AppointmentDate» at our office located at: «StreetAddress» «City», «PostalCode». Please arrive 10 minutes early so we can complete any required paperwork. If you have questions, contact us at (555) 123-4567 or reply to this email. Sincerely, [Your Company Name] [Contact Details]Print envelopes and labels by starting an Envelopes or Labels merge on the Mailings tab, selecting the correct size or vendor product number, then inserting your address merge fields and connecting the same Excel list. The process mirrors letters but adds a couple of layout steps.

«FirstName» «LastName» «StreetAddress» «City», «PostalCode»Send personalized emails by building the message in Word as an E-mail Messages merge, linking your Excel file, inserting merge fields in the body, and choosing Finish then Send E-mail Messages. Word assembles each message and Outlook does the actual sending, one email per row.
If you prefer to send through Gmail, read Mail Merge with Gmail.
Handle empty cells with a fallback or a conditional block, never by typing “n/a” into the sheet. Real spreadsheets have gaps: a missing first name, a second order number that only some rows have, a seat count for people who booked and nothing for people who did not. Leave those cells empty and let the merge decide what each person reads.
In Word, the Mailings tab gives you Rules, If Then Else, and Suppress Blank Lines for printed letters. They work, but the field codes are easy to break, and they only cover the document, not the email subject. In an email platform the same logic lives in the merge tag itself:
| What you need | Word mail merge | Mailsoftly merge tag |
|---|---|---|
| Replacement text for a blank name | Greeting Line with a default | {(first_name OR "there")} |
| A sentence only for people with a value | Rules, If Then Else | {(IF Seats booked)} ... {(END)} |
| A sentence only for people without it | Rules, If Then Else | {(IF NOT Seats booked)} ... {(END)} |
| A comma only when a second value exists | An IF field code typed by hand | {(Order2 PREFIX ", ")} |
| Hide a whole block when a cell is empty | Suppress Blank Lines (print only) | Row display condition “Show only if the field is filled” |
Every column you import becomes a field, so the header “Seats booked” becomes {(Seats booked)}. The Personalize menu lists them all, with a Handle empty fields group that inserts the fallback, PREFIX and IF forms for you, and the same tags work in the subject line and the preview text. Then open the recipient with the empty cell and the one with every cell filled, and read both copies before you send.

Word can merge your Excel rows into a letter for every person and save the result as a PDF. Emailing each person their own PDF is where it turns manual: Finish & Merge produces one combined file, and Word’s email merge cannot attach files at all.
An email platform removes the export, split and matching steps. In Mailsoftly you import the same Excel sheet, write the letter as a saved template with the same merge tags, and choose it as the campaign’s personalized attachment. At send time it builds one PDF per row, with every field filled and a file name that merges too, so a file named Certificate {(first_name)} {(last_name)} arrives as each person’s own file. Shared files that everyone should get, such as a schedule, can go on the same email.
Before sending, the PDF preview steps through real recipients, so you can check the row with the empty cell as easily as the complete one. Then choose the delivery: attach the PDF to the email, or send a secure link where the recipient confirms an access code or a detail you hold, such as a member number, before the document opens. Personalized attachments work for lists of up to 5,000 recipients and are switched on per account by the support team. See how to create and preview personalized PDFs and our full guide to mail merge with attachments.

Most mail merge problems trace back to mismatched field names, a broken Excel link, or formatting that Excel and Word interpret differently. Each has a quick fix. The table below maps the most frequent issues to their likely cause and the fastest solution.
| Issue | Possible Cause | Solution |
|---|---|---|
| Blank merge fields | Header names in Word do not match Excel exactly | Verify spelling, capitalization, and remove extra spaces in both Excel and Word |
| Errors like Error! or empty brackets | Word cannot locate the Excel data source | Re-link the correct file, ensure it is not open in Protected View, and confirm the worksheet name |
| Dates appearing as numbers | Date fields not formatted in Excel | Format the column as Date (for example, MM/DD/YYYY), save, and re-connect to Word |
| Addresses misaligned on labels | Label dimensions not matching your label sheets | In Mailings then Start Mail Merge then Labels, click Options and select the correct vendor and id |
| Emails marked as spam | Generic subject lines or suspicious formatting | Personalize the subject line, avoid spammy words, include a plain-text version if HTML |
| Duplicate emails sent | Duplicate rows exist in Excel | Sort by the email column, remove duplicates before merging |
| Script hitting Gmail limits | Sending too many emails too quickly | Add a pause between sends or split the list into smaller batches |
The best practices for reliable mail merge are to suppress blank fields, keep your contact list clean, test on a small subset first, and protect sensitive data. Beyond the core steps, these habits keep your merges professional and repeatable.
You automate mail merge with VBA by writing a short macro in Excel that launches Word, opens your merge template, attaches the active workbook as the data source, and runs the merge to a new document. This removes repetitive manual clicks for users who merge frequently.
Sub RunWordMailMerge() Dim wdApp As Object Dim wdDoc As Object Dim templatePath As String Dim dataSourcePath As String templatePath = "C:\Users\YourUserName\Documents\MailMergeTemplate.docx" dataSourcePath = ThisWorkbook.FullName Set wdApp = CreateObject("Word.Application") wdApp.Visible = True Set wdDoc = wdApp.Documents.Open(FileName:=templatePath) wdDoc.MailMerge.MainDocumentType = wdFormLetters wdDoc.MailMerge.OpenDataSource Name:=dataSourcePath, ConfirmConversions:=False, ReadOnly:=True, LinkToSource:=True, AddToRecentFiles:=False, Revert:=False, Format:=0, Connection:="", SQLStatement:="SELECT * FROM `Sheet1$`" With wdDoc.MailMerge .Destination = wdSendToNewDocument .SuppressBlankLines = True .Execute Pause:=False End With wdDoc.Close SaveChanges:=False End SubThisWorkbook.FullName to reference the active Excel file automatically.Handle advanced edge cases by unhiding filtered rows, matching encoding for special characters, simplifying conditional logic, and splitting very large lists. Even seasoned users hit these less common hurdles. Here are practical solutions.
{ IF «SubscriptionLevel» = "Premium" "Thank you for being a Premium member!" "Enjoy 10% off your next purchase!" }A complete mail merge workflow runs from a clean Excel workbook to a finished print or email send in eight repeatable steps. Below is an end-to-end example for a batch of appointment reminder letters that you can adapt to any campaign.
| Step | Action |
|---|---|
| Prepare Excel Workbook | • Create a sheet named Appointments. • Headers: FirstName, LastName, StreetAddress, City, PostalCode, AppointmentDate. • Populate each row. |
| Save Excel File | • Save as C:\MailMerge\AppointmentReminders.xlsx. |
| Open Word Template | • Launch Word and create a new document. • Design the letter layout (company letterhead, logo at top). |
| Connect Data Source | • In Word, go to Mailings then Select Recipients then Use an Existing List, select the file, and choose the Appointments sheet. |
| Insert Merge Fields | • Place the cursor after Dear and insert «FirstName» followed by «LastName». • Insert «StreetAddress», «City», «PostalCode» under the address block. |
| Add Appointment Field | • In the body, write Your appointment is scheduled for and insert «AppointmentDate». |
| Preview and Adjust | • Click Preview Results to check formatting, spacing, and field placement. • Use the arrows to navigate records. |
| Finish & Merge | • Click Finish & Merge then Edit Individual Documents to generate a combined Word file, then print on letterhead or save as PDF and distribute. |
Manage mail merge over time by versioning your Excel lists, enforcing data validation, documenting your workflow, and securing sensitive files. These habits keep accuracy and efficiency high as your lists and team grow.
Moving beyond Excel mail merge can cost nothing to start. Mailsoftly’s free plan covers 500 contacts and 2,000 emails per month with your Gmail, Outlook, Google Workspace or Microsoft 365 account with no credit card, and paid tiers scale up from there. Pricing below is as of 2026-04-15.
| Plan | Price | Contacts | Emails / month |
|---|---|---|---|
| Free | Free | 500 | 2,000 |
| Basic | $39/mo annual ($49 monthly) | 5,000 | 40,000 |
| Business | $79/mo annual ($99 monthly) | 15,000 | 150,000 |
| Premium | $159/mo annual ($199 monthly) | 30,000 | 300,000 |
| Enterprise | Custom | Unlimited | Unlimited |
The practical takeaway: if you are sending to a few dozen contacts once a quarter, Excel mail merge is fine. Once you cross a few hundred recipients, want open and click data, or need authentication that keeps you out of spam, a platform pays for itself in saved hours and recovered deliverability.
Mail merge with Excel is a powerful technique that transforms raw data into polished, personalized communications. Whether you send appointment reminders, invoices, invitations, or holiday greetings, a robust mail merge workflow can save countless hours and reduce errors. To recap:
By following these best practices, your mail merge projects will run smoothly, produce professional results, and scale as your lists grow. With mail merge, Excel becomes more than just a spreadsheet. It becomes the engine for personalized, data-driven communication.
When the list outgrows Word and Outlook, the same sheet can drive a mail merge with conditional text and a PDF for every row, without the export and split steps.
For the broader picture on this topic, see our complete Email Marketing Fundamentals guide, which covers strategy, fundamentals, and advanced playbooks.

Prepare your data in an Excel sheet with one row per recipient and clear column headers, then open Word or your email tool and choose the mail merge option. Connect the Excel file as the data source, insert merge fields where names and other details belong, preview a few records, and finish the merge to print or send. For large email sends, a bulk email platform like Mailsoftly handles the same personalization with deliverability controls built in.
In Word, merge to individual documents, save them as PDF, then split the file into one PDF per person with a macro or a PDF tool and attach each one by hand. Mailsoftly skips those steps: import the sheet, choose a saved template as the personalized attachment, and it builds one PDF per recipient at send time, named after that person, then attaches it or sends it behind a secure link.
Not on its own. Excel stores the data but relies on Word and Outlook to assemble and send the messages. A dedicated platform imports your Excel file directly and sends each personalized email itself, with built-in analytics and authentication.
Format dates as Date in Excel (for example, MM/DD/YYYY) so Word reads them correctly, and format ZIP or postal codes as Text to preserve leading zeros. Set both before connecting the file, then re-link the data source if you change them.
Merged emails land in spam because of sending limits, missing authentication, and repetitive content that filters distrust. Personalize subject lines, send in smaller batches, and use a platform that authenticates your domain and manages sender reputation to improve deliverability.
Yes. Word’s email merge lets you insert a merge field into the subject line, so each message can include a name or order number. A platform makes this easier by adding fallback logic when a field is empty, so no subject reads awkwardly.
Leave the cell empty and handle it in the template. In Word, use Rules and Suppress Blank Lines. In Mailsoftly, give the tag a fallback, such as {(first_name OR "there")}, or wrap the sentence in {(IF field)} ... {(END)} so people without the value never see it. Then preview a recipient with the empty cell before sending.
Not as an attachment: an attached PDF goes out as it is. For sensitive documents, Mailsoftly’s secure link delivery sends each person a personal link, and they confirm an access code or a detail on file before their PDF opens. You send the code separately, for example in a second email, and the downloaded file can be locked with that same code.
An email platform is better once you need scale, reusable templates, personalization with fallbacks, open and click analytics, and reliable delivery that bypasses consumer-inbox limits. For one-off sends to a small list, manual Excel mail merge is still perfectly fine.
Send your next mail merge with tracking and personalizationStart free with Mailsoftly →
500 contacts, 2,000 emails per month with your Gmail, Outlook, Google Workspace or Microsoft 365 account. Merge fields and open tracking included. No credit card.
