I am looking for an ASP.NET solution to perform document processing (editing and storing) with mail-merge capabilities (variable substitution) that will output a set of documents from a template to a PDF file. I require the ability to supply named substitutions from a SQL server table. Users will need the ability to upload, create, edit, and save their document templates.
This solution should ideally (though not necessarily) use Microsoft Word file formats. Using ‘in the cloud’ technology will be preferable as opposed to having the user create anything on the desktop for subsequent upload (with the exceptions of templates the user might already have); it is possible that Microsoft may already make an SDK available as this functionality was recently announced.
Preference will be given to a solution written in VB.net and please encapsulate your code into a separate class (whether vb or c#).