🎉  Build a workflow powerhouse. Learn more about our new Airtable integration.   🎉

July 22, 2016

Instantly Send Proposals for New Opportunities in Microsoft Dynamics CRM

Streamlining your sales process can have huge benefits to both your customers and your sales team.  From helping your sales team track leads to closing deals faster, with a tool like Microsoft Dynamics CRM you can put your best foot forward.

Along with the sales process comes the paperwork and with a tool like WebMerge, you can automatically generate all kinds of documents like invoices, quotes, contracts, and more.  In this example, we’re going to show you how to automatically generate a proposal for new opportunities that are added to Dynamics CRM.

To get started, we’re going to setup the template for our proposal using a Word document.  Inside our Word document, we’re going to include our boilerplate proposal information, and then for the spots that we want data from our opportunity to be inserted, we’re going to add merge fields like {$FirstName}, {$OpportunityName}, etc.

Here’s what our proposal template looks like:

Once you have your template ready, we need to upload it to WebMerge.  Form the Documents page in WebMerge, click the New Document button and then enter a name.  On the next step, pick Office Document as the document type and then select the file from your computer.

After you upload your template, you’re going to be taken to the Settings tab where you can update various settings like the type of file that is generated and the name of the file.  For this example, we’re going to generate a PDF and include the name of our opportunity in the name of the file.

Next, we’re going to setup the Email delivery so that our proposal is automatically emailed to our client when it is generated.  Under the Deliver tab, go ahead and Edit the default email delivery.  For the “To” address, we’re going to change that to the merge field for our contact’s email address.  Feel free to change any of the other settings for the email.

After we have our email delivery saved, we’re ready to integrate our proposal template with Microsoft Dynamics CRM.  To help with the integration, we’re going to use our friends over at Zapier.

Inside Zapier, go ahead and create a New Zap.  For the Trigger, we’re going to choose Microsoft Dynamics CRM as the service and then New Opportunity as the trigger.

After you authenticate your Dynamics CRM account, Zapier is going to load a test opportunity from Dynamics CRM to make sure everything works correctly.  Follow those steps and move on.

Next, we’re going to setup the Action of our Zap.  For the service, select WebMerge and then Create Document Merge as the action.

Once you authenticate your WebMerge account, Zapier is going to load a list of the documents in your account.  Go ahead and pick the proposal template that you just setup in WebMerge.  Once you pick the template, Zapier will load a list of all the merge fields in your template.

For each of the merge fields you need to pick the corresponding field from Dynamics CRM.  This tells Zapier how to send the data over to WebMerge so that it gets populated in the correct spot on your template.

Once you have matched up all of your merge fields, go ahead and save your zap and then turn it on.  We’re ready for a test! Login to Dynamics CRM and create a new opportunity.  Zapier will detect this new opportunity and send the data over to WebMerge.

Here’s what our proposal looked like:

Congrats, you’re all finished!  You can now automatically generate all kinds of documents from Microsoft Dynamics CRM.  Can you think of any other ways that you could use WebMerge to simplify your paperwork process?

6 min read

Ready to give Formstack Documents a try?
Start your Free Trial now!


Create Proposals from Microsoft Dynamics CRM Now

By signing up here, you agree to our Terms of Use