Answered by:
How to Create Word Template in CRM 4

Question
-
Microsoft made life earlier in Office Accounting, to print or email a customized quote, invoice to customer was simple as abc, I just need to go to "Manage Word Template" where I can create or modify a Word template (Quote, invoice, sales order etc.), but in Dynamics CRM 4.0, I just cannot figure out how to go about doing this.
To do the above in CRM 4:
After creating a quote, I click on "print quote for customer" and a dialog box opens, where I select my personal mail merge template, then another dialog box opens "Mail Merge Recipients" from this point I don't seems to get my template populated with the quote i generated in CRM.
I will be okay if i can just get a template that is similar to the report generated (when i click on "Report"), but with my company logo.
Is there a way i can do this in CRM 4?
Regards,
DE-D
DE-DMonday, August 16, 2010 5:48 PM
Answers
-
Originally I thought the "Print Quote for Customer" feature, and improved mail-merge features of CRM would alleviate my business' quoting troubles. However, I soon learned that the mail merge process has a limit to the number of fields you can pass from the Quote (and related) records (maximum of 62)... which impacted our process. We switched to using custom reports from SSRS, which we export to PDF documents. SQL Server 2008 R2 supports the direct export of reports to Word format, which is the only other way to get a Word document out of CRM without using the mail-merge feature. That said, it's a lot harder to produce text formatting in a report than with a Word template.
From the Settings area, you can navigate to Templates and identify (by selecting the "All Mail Merge Templates" view) the "Quote for Customer" or custom template you've created. By opening the template record, you can examine the "data fields" by clicking on the button of the same name. From this dialog, you can pick the fields which are submitted to the template.
There are many sites that have helpful tips on processing a mail-merge. I personally found, however, that our sales staff were routinely unsavvy with all things technical, and could not be trusted to perform a mail-merge with any sufficient degree of competence. This and the field limitation are ultimately what drove me to seek out an SSRS replacement.
http://blogs.msdn.com/b/crm/archive/2008/01/15/mscrm-4-0-mail-merge-basics.aspx
http://dmcrm.blogspot.com/2008/01/word-mail-merge-one-page-quote-with.html
http://dmcrm.blogspot.com/2008/04/word-mail-merge-part-2-getting-line.html
Good luck!
Dave Berry - MVP Dynamics CRM - http:\\crmentropy.blogspot.com- Proposed as answer by Mayank Pujara Thursday, August 19, 2010 8:22 AM
- Marked as answer by DavidJennawayMVP, Moderator Friday, September 17, 2010 10:05 AM
Monday, August 16, 2010 9:15 PMModerator
All replies
-
Originally I thought the "Print Quote for Customer" feature, and improved mail-merge features of CRM would alleviate my business' quoting troubles. However, I soon learned that the mail merge process has a limit to the number of fields you can pass from the Quote (and related) records (maximum of 62)... which impacted our process. We switched to using custom reports from SSRS, which we export to PDF documents. SQL Server 2008 R2 supports the direct export of reports to Word format, which is the only other way to get a Word document out of CRM without using the mail-merge feature. That said, it's a lot harder to produce text formatting in a report than with a Word template.
From the Settings area, you can navigate to Templates and identify (by selecting the "All Mail Merge Templates" view) the "Quote for Customer" or custom template you've created. By opening the template record, you can examine the "data fields" by clicking on the button of the same name. From this dialog, you can pick the fields which are submitted to the template.
There are many sites that have helpful tips on processing a mail-merge. I personally found, however, that our sales staff were routinely unsavvy with all things technical, and could not be trusted to perform a mail-merge with any sufficient degree of competence. This and the field limitation are ultimately what drove me to seek out an SSRS replacement.
http://blogs.msdn.com/b/crm/archive/2008/01/15/mscrm-4-0-mail-merge-basics.aspx
http://dmcrm.blogspot.com/2008/01/word-mail-merge-one-page-quote-with.html
http://dmcrm.blogspot.com/2008/04/word-mail-merge-part-2-getting-line.html
Good luck!
Dave Berry - MVP Dynamics CRM - http:\\crmentropy.blogspot.com- Proposed as answer by Mayank Pujara Thursday, August 19, 2010 8:22 AM
- Marked as answer by DavidJennawayMVP, Moderator Friday, September 17, 2010 10:05 AM
Monday, August 16, 2010 9:15 PMModerator -
In Addition to Dave's list, please check out following video as well..
http://www.democrmonline.com/MailMerge/
MayankP My Blog My twitter- Proposed as answer by Mayank Pujara Thursday, August 19, 2010 8:22 AM
Tuesday, August 17, 2010 12:56 PM