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

Notifications

Announcements

No record found.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans