From inside VB.Net (VS-2008) I am trying to connect to a Word Mailmerge document and populate it with data from a query. I have the word document Master with all the relevant fields set up located on our local server, and a query in VB.Net ready to send the data to Word.
SQL Server 2008 is located on our web server and Word is located on all the local Users machines.
Ideally, I would like the users to be able to activate the query from a button control, have the code open Word and populate the relevant fields, allow the user to edit any fields they wish, and then save the document to a name of their choice, before exiting word. i.e. the Master is never over-written.
I have been searching for a method of achieving this but cannot find what I need to solve this challenge.
Please can you help?
View Complete Post