Tuesday, 31 March 2015

CRM Mail Merge Tips: How to Enable CRM Add-in Without Installing CRM for Outlook Connector

As we know that we can do ‘Mail Merge’ in CRM.

Then you just perform the ‘Mail Merge’ action from the ribbon for the Quote record then you download the Word file.


After that you download and open the Word file, you realize that you read this section…


Then if in this case you cannot see the CRM button, you are probably facing the same problem with me right now, because I can’t see this icon.


*As we can see, in the ‘Mailings’ tab, there is no CRM button appearing.


You can try to download the CRM for Outlook Client, it will add the Mail Merge functionality, some add-in that make you will be able to click this CRM button.

It will add the template inside this folder..


But, now, I am in kind of hurry, I don’t have enough time to download the installer, install it, and then configure it, what should I do?

A quick tips as a core from this blog post is basically you can just download the template from this URL:



*For CRM Online you just change the IP and Port using your CRM URL just before the /_static/….

After that, you just download the Template and then go to the Options here in your MS Word App.


Just follow the steps above.

And then click Go…

Then attach here:


Change the location to your template location.

Then OK.

And here is the result



*As we can see, there is the CRM button, the button that we have been waiting for to come in.



You need to enable Editing + Macro to make it works.


Another tips, you can store the template to this location:


So that every time you open the File Location, it will be redirected by default to this location and you can just choose the CRMTemplate.

This is a shortcut, fast way to do ‘Mail Merge’ without installing CRM for Outlook Client.

Hope this helps!


Thursday, 5 March 2015

Can’t Mapping Campaign Response Fields to Lead in CRM

As we know that we can convert Campaign Response to create new lead easily.


Then it will open new Lead form which is you need to fill the completion, but it does some fields mapped by default, such as Subject, Company name, Last Name, etc.

But, the problem here, what if I want to copy other fields? Other new field, or even existing fields such as Promotion Code?

The first time, I was thinking about mapping, like what CRM did for the fields like Subject, CRM has existing mapping, but in fact, you cannot modify it by default.

It is connected by Related Campaign Response field.



As we can see, no Mapping could be edited here.

So, the second time I was thinking to use workflow.

I did create the workflow:


I want to copy Promotion Code from Campaign Response to Lead description.


I thought everything will be okay after I create this workflow.

So, I convert the Response to Lead.

But, in fact, after I convert it to Lead, I still have to Save first in order to make the workflow working, it’s different from CRM Opportunity to Quote that will automatically create the Quote directly, no matter what.

However, after I save it, the mapping still doesn’t work.

After I check the Log, it was because the Related Campaign Response field in the Lead was blank and did not get mapped at all.


I check the Advanced Find, no data for Lead with Related Campaign Response containing data.

Then, I try to put it to the Lead Form.

It turns out that this field is never been unlocked.


And it never have any value on it, so that I think it’s a flaw/bug that the Lead in fact has no relationship with the Response at all, what if we want to know, which Response is becoming the Lead original source?

I did try to unlock it using Business Rule, but no luck.

I have submitted to this Microsoft Connect.

Kindly you help me to vote it up.

So, I‘ve been thinking to use another workaround. I realized that I could edit mapping from Opportunity Product to Quote Product even though the mapping is not editable through OOB UI.

So here are my steps:

1. Get the Mapping ID

If you are using CRM 2015 you can try to get the mapping ID and follow this instruction:

Or I can put the steps here:

*For CRM Online, you can obtain the mapping ID through:

To get the mapping Id you can hit this URL:
https://mycrmonlineorg.crm5.dynamics.com/XRMServices/2011/OrganizationData.svc/EntityMapSet?$select=EntityMapId&$filter=TargetEntityName eq ‘lead’ and SourceEntityName eq ‘campaignresponse’

So will get the mapping Guid.

*For OnPremise, you can use above method or use this SQL query to get the mapping ID:

SELECT EntityMapId
FROM EntityMapBase
WHERE TargetEntityName='lead' AND SourceEntityName='campaignresponse'

So will get the Mapping Id


Now copy the ‘88F8FF60-DEC3-E311-9408-001CC4EECDD6’

And paste to this pattern of URL:


Will become:



Now, you can see the list of existing mapping.

Please, create new One.

I create new one for the Promotion Code Name.

*Remember for the Mapping, make sure that both fields are in the same date type, the target field should not have less length allowed compared to the source field, then for Option set make sure it is an Option Set, otherwise it will fail.


Then, to make sure, please Publish All Customizations.

But, the result..


Still I cannot get the Promotion Code to be mapped to the Lead.

I guess because there is no direct relationship because in the Lead we cannot get any related Campaign Response.

So that would be not working as well.

Overall, you cannot use Workflow for this mapping as well.

So the possibilities here:

1. Either customize the Convert ribbon, copy it and creating new one with your own dialog or control.

2. Create new relationship between Campaign Response and Lead then you create the new mappings, and you can create the Lead through subgrid or associated view

3. Utilize the mapped fields, such as Subject, First Name, Last Name, Description to get get the Campaign Response source and then use workflow or plugin or javascript to get fields from the original Campaign Response. You need to query to get the exact Campaign Response.

If you have any other suggestion, I will be so happy.

Thank you!