AI in Practice

Copilot drafts personal letters for mail merges in Word

3 min read

TL;DR Too Long; Didn’t read

Copilot writes the base text for a mail merge letter in Word, such as an invitation or a customer letter. Word's mail merge function then automatically combines this text with a mailing list from Excel or Outlook. This produces many personally addressed letters without typing each one by hand. Copilot needs a paid add-on license; the mail merge function itself is included in every version of Word.

A laptop displays a Word document with the Copilot logo, next to it is a stack of personalized envelopes with different names, fanned out from a mailing list. Image generated with GPT Image 2

Key takeaways

  • Copilot writes the letter text, Word's mail merge function personalizes it automatically for each recipient.
  • The mail merge function is included in every version of Word and costs nothing extra.
  • According to Microsoft, Copilot in Word costs from 15.60 euros per month, on top of the Microsoft 365 subscription.
  • Available for Windows, Mac, and the web, including in Germany and the rest of the EU.
  • An Excel spreadsheet or the Outlook address book with names and addresses serves as the data source.
  • Copilot-written text needs a quick check for tone and accuracy before it goes out.

Writing a personal invitation or customer letter for fifty people by hand usually takes a lot of time. Copilot in Word writes an initial letter text, which Word’s mail merge function then automatically connects with names and addresses from a list. The result is a finished, personally addressed letter for every recipient, without typing each line by hand.

Copilot supplies the text, Word handles the personalization

Copilot takes over the first draft in Word. A short prompt like “Write an invitation to the customer event” produces a finished draft with a subject line, placeholder salutation, and closing sentence. According to the Microsoft help page on drafting content, Copilot only generates a suggestion that can be kept, discarded, or regenerated.

The actual personalization - name, address, individual salutation - is then handled by Word’s mail merge function, which has existed long before Copilot. The two features complement each other: Copilot supplies the text, mail merge handles the bulk processing for many recipients at once. Depending on the Word version and the Copilot rollout, the exact menu item may be named or placed slightly differently.

How the mail merge comes together in six steps

An example from office life: an assistant sends an invitation to the annual party to fifty business partners. The whole process runs inside Word, with no extra program needed:

  1. Open a Word document and draft a base letter text with Copilot
  2. Prepare a mailing list with name, salutation, and address in Excel or the Outlook address book
  3. Start mail merge from the “Mailings” menu and link the mailing list
  4. Insert mail merge fields such as salutation and name into the Copilot text at the right spots
  5. Check the preview of the individual letters and adjust the wording if needed
  6. Finish the mail merge and combine all letters into one file or print them directly

A clerk types the letter only once and never has to enter names or addresses by hand. Copilot already applies this same pairing of text and automation in Outlook, where it adjusts email drafts directly in tone. In Word, Copilot only handles the text - distributing it to many recipients remains the job of mail merge.

Costs, availability, and requirements at a glance

The mail merge function is included in every version of Word and costs nothing extra; a mailing list in Excel or the Outlook address book is enough as a data source. Copilot, on the other hand, needs a paid add-on license on top of an existing Microsoft 365 subscription. According to the official Microsoft price list, Microsoft 365 Copilot Business currently costs 15.60 euros per user per month, a promotional price running until the end of September 2026; the regular price of 18.20 euros applies after that. Both features are available in Germany and across the EU, for Windows, Mac, and the web.

Since the mailing list contains real customer or employee data, it falls under the same access rights as other customer data. Copilot itself only reads the entered letter text, not the entire mailing list automatically.

Copilot does not replace a final review: with sparse prompts, it sometimes suggests an inappropriate tone or incorrect details that should be corrected before sending. Very elaborate mail merges with conditional text blocks - different paragraphs depending on customer group, for instance - still need the classic Word field function; Copilot only supplies the first text draft, not the logic behind it.

Frequently asked questions

What does Copilot in Word cost?

Microsoft currently states the add-on license at around 15.60 euros per user per month at the promotional rate, rising to about 18.20 euros from the end of September 2026 - each on top of the Microsoft 365 subscription. The mail merge function itself is free to use without Copilot.

Is an account or subscription needed to follow these steps?

A regular Word subscription or a locally installed version is enough for the mail merge itself. Drafting the text with Copilot additionally requires a paid Microsoft 365 Copilot license.

Does this work in German and across the EU?

According to Microsoft, Copilot in Word is available in German as well as throughout Germany and the EU. The mail merge function itself is included in every language version of Word regardless of Copilot.

Can customer or company data go into the mailing list?

Yes, that is the normal purpose of the feature, but the list should be handled with the same restricted access as other customer data. Copilot itself only reads the entered letter text, not the entire mailing list.

Are there alternatives to Copilot?

The letter text can equally be drafted with ChatGPT or Google Gemini and then personalized in Word or Google Docs via mail merge. Without AI, the classic mail merge still works the same way, it just takes longer to draft the text.

Sources (3)
  1. Use mail merge to personalize letters (Microsoft Support)
  2. Draft and add content with Copilot in Word (Microsoft Support)
  3. Microsoft 365 Copilot Pricing (Microsoft)

Your AI update for the work week

Once a week, the most important AI news – plus one practical tip to try right away. No spam, unsubscribe anytime.

← Back to the blog