VSTO
-
Hi All, I need to create a document management system. In this we need to generate multiple Appointment Letter to send Email to different customer, However i Will have only one appointment template(May be in MS Word, which is easy for editing). Some thing similar to mail merge but email address should come from sqlserver. I search around google and found VSTO will solve this. Please Advice me. Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com
-
Hi All, I need to create a document management system. In this we need to generate multiple Appointment Letter to send Email to different customer, However i Will have only one appointment template(May be in MS Word, which is easy for editing). Some thing similar to mail merge but email address should come from sqlserver. I search around google and found VSTO will solve this. Please Advice me. Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com
Are these documents system generated? For instance, will the user click a button then have the documented created? If so then you don't need VSTO, you can use Word Interop to insert the email address into the letter template before sending to user.
Failure is not an option; it's the default selection.
-
Hi All, I need to create a document management system. In this we need to generate multiple Appointment Letter to send Email to different customer, However i Will have only one appointment template(May be in MS Word, which is easy for editing). Some thing similar to mail merge but email address should come from sqlserver. I search around google and found VSTO will solve this. Please Advice me. Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com
I suppose you need to do document generation from a .NET application. Note that Office COM (interop) is a very bad option in general (http://support.microsoft.com/kb/257757[^]). It can be used in Windows (desktop) applications, but avoid using it on server side (ASP.NET, windows services, ...). You I think there are only 2 viable options: - Open XML SDK - 3rd party solution If you are willing to forge your own document generation solution then you can choose Open XML SDK (you will find a lot of Open XML links - just google a bit). But this path requires a lot more work and Open XML learning curve is much steeper compared to Office COM. I think it is usually better to buy a 3rd party library does the job done without much effort. You can take a look at Docentric toolkit[^]. It offers everything you need and also has a handy MS Word Add-In for template design and placeholder data-binding.