Mail merge letters in Cloud Docs

Updated November 13, 2026

Mail merge makes one letter for each person on a list. You write the letter once with fields such as First Name in it, and Cloud Docs fills them in for each recipient. It works in the browser and in the desktop app. Emailing the results through Outlook and using Outlook contacts need the desktop app on Windows.

1. Make your list

Your list can be:

  • an Excel workbook (.xlsx): its first sheet is used
  • a CSV file (.csv)
  • a tab-separated file (.txt or .tsv)

The first row names the fields, for example First Name, Last Name, Address and E-mail Address. Each row after it is one recipient.

2. Pick the recipients

  1. Open or write your letter.
  2. On the Mailings tab, choose Recipients and pick your list.

The Start group shows how many recipients were read, such as “24 recipients”.

3. Put fields in the letter

  1. Put the cursor where a field goes, for example after "Dear ".
  2. Choose Merge field and pick the field.
  3. Repeat for each field you need.

4. Preview

Choose Preview to see the letter with the first recipient’s details. Use Previous and Next to step through the list. The Preview group shows which one you’re on, such as “2 of 24”. Choose Preview again to see the fields.

5. Finish and merge

Choose Finish & merge. A new tab opens with a letter for each recipient, named Letters followed by your document’s name. Save it, print it or save it as a PDF like any other document.

Email each letter (desktop app with Outlook)

In the desktop app on Windows with Microsoft Outlook installed, you can send each letter as an email:

  1. Pick your recipients as above. The list needs an email address column.
  2. Choose E-mail messages.
  3. In To, pick the field that holds the email address, and type a Subject line. A field in the subject, written like «First Name», is filled in for each person.
  4. Choose to save the messages in Outlook’s Drafts, to look over and send, or to send them now.
  5. Choose Save in Drafts, or Send followed by the number of messages.

The dialog shows how many recipients have an address. Rows without one are skipped.

You can also choose Outlook contacts to use your Outlook contacts as the list.

In the browser, Outlook contacts and E-mail messages say they’re available in the desktop app. To email letters from the browser, finish and merge, then save or send them yourself.

Was this article helpful?