Work with mail merge templates - Power Platform (2024)

  • Article

Important

The mail merge template feature has been deprecated and is not supported. In Dynamics CRM 2016 (version 8.0), we introduced server-side document generation using Word and Excel templates. You can use these templates to provide standardized documents or customized data analysis for your organization.

You can use mail merge templates with Office Word to create customer-ready letters, faxes, e-mail messages, and quotes.

Word templates are created and edited in Word, but can be uploaded to customer engagement apps (Dynamics 365 Sales, Dynamics 365 Customer Service, Dynamics 365 Field Service, Dynamics 365 Marketing, and Dynamics 365 Project Service Automation), to use with mail merge and share with other users. Only Word .xml documents can be used as templates. To learn more about how to create mail merge templates, see the online Help in Word.

  1. Make sure you have the System Administrator security role or equivalent permissions in Microsoft Dynamics 365.

    Check your security role

    • Follow the steps in View your user profile.

    • Don’t have the correct permissions? Contact your system administrator.

  2. In the Power Platform admin center, select an environment.

  3. Select Settings > Templates > Mail merge templates.

  4. To create a new mail merge template, select New.

  5. In the Mail Merge Templates form, enter a Name and an Associated Entity (record type).

  6. You can enter a description of the template. This is not displayed to the recipient.

  7. Select Save.

  8. Select Data Fields, select the columns to add as fields in your email, and then select OK.

  9. Select Save, and then select Create Template in Word.

  10. Select Add-ins, and then select CRM.

  11. Proceed through the Mail Merge process and save the template.

  12. Return to the Mail Merge Template page, and then select Choose File.

  13. Select the newly created mail merge document, select Open, and then select Attach.

  14. Select Save and Close.

Note

To change a personal template to a shared one, after you save the record on the template form, on the More Actions menu, select Make Available to Organization. To revert the template to a personal one, select Make Personal.

Use a mail merge template

After creating a mail merge template, follow these steps to use it.

  1. In the Power Platform admin center, select an environment and open it.

  2. Select Advanced Find and select the customers to send an email.

  3. Select Mail Merge, choose the Personal mail merge template, and then select Download.

  4. Open the downloaded file in Microsoft Word and go through the steps.

Work with mail merge templates - Power Platform (2024)

FAQs

Work with mail merge templates - Power Platform? ›

In the Power Platform admin center, select an environment. Select Settings > Templates > Mail merge templates. To create a new mail merge template, select New. In the Mail Merge Templates form, enter a Name and an Associated Entity (record type).

How to use a template in mail merge? ›

Click Start from a template. Click Select template. On the Mail Merge tab, select the template that you want in the Select Template dialog box, and then click OK.

What two software programs do you need to use when creating a mail merge? ›

Data sources

Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information. Excel spreadsheets and Outlook contact lists are the most common data sources, but if you don't yet have a data source, you can type it up in Word, as part of the mail merge process.

What are the disadvantages of mail merge? ›

Disadvantages Of Mail Merge

Too much work setting everything up. Way too many errors to deal with. Can't automate follow-up emails. No spam control.

Is mail merge obsolete? ›

The mail merge template feature has been deprecated and is not supported. In Dynamics CRM 2016 (version 8.0), we introduced server-side document generation using Word and Excel templates. You can use these templates to provide standardized documents or customized data analysis for your organization.

What is the difference between mail merge and template? ›

Email templates

For example, if we wanted to address an email recipient by their first name, we could write an email template. A mail merge is the process of generating form letters and other Microsoft® Word documents that are personalized for the recipient, who is often a contact or lead.

How to use Power Automate and mail merge? ›

Steps to Automate a Mail Merge in Power Platform
  1. General Process.
  2. Enable Developer tab in Word.
  3. Create a Document Word Template with Bookmarks.
  4. Add Bookmarks to Document.
  5. Add a Table with Repeating Rows.
  6. Save the document to SharePoint.
Mar 14, 2023

Is there something better than mail merge? ›

1PointMail, a cloud-based marketing solution for email marketing, allows users to increase their email marketing return of investment (ROI). 1PointMail allows users to optimize marketing campaigns, manage lists and track campaign results in real-time.

Does mail merge work in SharePoint? ›

Yes, it is possible to use a source file stored in SharePoint as a data source for Mail Merge in Microsoft Word. To do this, you can follow these steps: Open Word and start a new document. Go to the "Mailings" tab, click on "Start Mail Merge" and select "Letters".

Which software is most compatible with mail merge? ›

Best Mail Merge Software for Gmail
  • Right Inbox. Mail merge personalization add-on that allows you to scale your email outreach within Gmail. ...
  • Streak. ...
  • Yet Another Mail Merge. ...
  • Mailmeteor. ...
  • Gmelius. ...
  • MixMax. ...
  • DragApp.

How to learn mail merge? ›

Here's a quick way to get started. On the MAILINGS tab, click Start Mail Merge and Step-by-Step Mail Merge Wizard. Select the type of document you want to add mail merge to, and click Next. Here you can start a new document from a template or existing document.

What app is used for mail merge? ›

🕵️ MAIL MERGE HIGHLIGHTS FOR BOTH GOOGLE DOCS ™ AND GOOGLE SHEETS ™ Personalize your email message body and your subject line to send unique emails to recipients in bulk/mass. Add CC, Bcc, Reply-To. Values can be static or merged from a column in your sheet.

How hard is mail merge? ›

Of course not; that would take hours. Lucky for you, Word's mail merge wizard makes the task fairly easy. Using mail merge, all you have to do is create one document that contains the information that is the same in each version. Then you just add some placeholders for the information that is unique to each version.

Which is not required for mail merge? ›

The correct answer is Microsoft Powerpoint. Microsoft Powerpoint is not a valid data source in a mail merge. Mail merge is a feature within most data processing applications that enables users to send a similar letter or document to multiple recipients.

Is there a limit to Microsoft mail merge? ›

Microsoft Office imposes no limits on how many records can be merged to email in one go. Your Internet Service Provider (ISP), however, may impose a limit (e.g. to deter people using its servers for spam).

How to edit mail merge template in Word? ›

For letters generated in Mail:
  1. Verify the desired conditional field is still selected. ...
  2. Scroll through list to find desired condition.
  3. Double-click on row to open record.
  4. Click Edit Merge Document.
  5. Make the appropriate changes to the merge document.
  6. Click on Add-ins in top menu bar in Word.
  7. Click Save and Return to RE7.

How do I add an Avery template into Word? ›

Downloading a Word Template from Avery.com
  1. Go to avery.com/templates.
  2. Enter your product number in the search box in the center of the page and click when your template appears.
  3. On the template detail page, look for Download Blank Templates and select your software program.

Top Articles
Latest Posts
Article information

Author: The Hon. Margery Christiansen

Last Updated:

Views: 6251

Rating: 5 / 5 (50 voted)

Reviews: 89% of readers found this page helpful

Author information

Name: The Hon. Margery Christiansen

Birthday: 2000-07-07

Address: 5050 Breitenberg Knoll, New Robert, MI 45409

Phone: +2556892639372

Job: Investor Mining Engineer

Hobby: Sketching, Cosplaying, Glassblowing, Genealogy, Crocheting, Archery, Skateboarding

Introduction: My name is The Hon. Margery Christiansen, I am a bright, adorable, precious, inexpensive, gorgeous, comfortable, happy person who loves writing and wants to share my knowledge and understanding with you.