web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

How to automate Mail Merge process

(0) ShareShare
ReportReport
Posted on by

Hi guys,

Is there a way to automate the Mail Merge process? We have been able to do so in CRM 4.0 probably using the Normal.dotm template.

With CRM 4.0, users start a mail merge within CRM using a template and then it opens the template in MS Word 2007 and starts the CRM add-in. After that they click on a custom button on the Word quick access toolbar (QAT) which automates all the mail merge steps as well so they do the whole process with one or two mouse clicks.

In CRM 2013, we start a mail merge within CRM using a template and then it opens the template in Word and then we get a pink comment box in the document. We then have to click on the Add-In ribbon on top and then click on the CRM add-in to initiate the mail merge. Then we click on the customized QAT button to execute all the steps. I know this seems like only two more clicks but for someone who generates 50 documents a day, this is 100 more clicks and it's cumbersome.

I am sure there is a way to execute this CRM add-in directly from the CRMTemplate.dot template using a maccro or something but I am very unfamiliar with these.

Any help would be appreciated.

Thank you,

Stéphane

*This post is locked for comments

I have the same question (0)
  • Verified answer
    tyborg77 Profile Picture
    45 on at

    Hi Stéphane,

    The mail merge can run automatically via the CRM for Outlook Add-in. I'm a bit vague on the details as to why (I think it had something to do with authentication) but Mail Merge and dynamic exports don't work properly via the browser in 2013.

  • Community Member Profile Picture
    on at

    Hi tyborg77,

    Thank you for taking the time to answer my question. What you are describing has been my experience. It's too bad that they did not include it as an option with CRM 2013. I have been able to automate most of the mail merge process using word maccros that I have included in the CRMTemplate.dot on the CRM server but there is still an extra step that I cannot automate which is the Internet Explorer security pop-up (What do you want to do with this file? Open/Save). It is still close enough to the CRM for Outlook client experience that our business is willing to go along with it. Hopefully we can lead them to use the CRM for Outlook client instead in a near future.

    Thanks again for your help,

    Stéphane

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans