How to run word and pass a data table as argument to mailmerge

B

Belinda

Hello All

I have the following requirement:

- I have a standard template document
I have a table in SQL Server that as some information that I want to
be substituted into this word template and the documents must be
generated to be sent by email.

Please advise what is the best way to implement this scenario.

In brief I want to create a template word file and a seperate data
table this must be mail merged and resultant output documents
generated. I want to email these documents to the receipients.

Please note I would like to start word from command line and pass the
template file and the mail merge list as well. I would like to call
word from SQL Server DTS tasks so only way I can do it is by calling
it in batch mode.

Please provide the command line syntax to invoke word and pass these
arguments.

Thanks
Belinda
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Changing a Mailmerge document to a normal document. 0
How to run word and pass a mail merge values and fax it to the recipient 2
Automating Access: running your own functions/passing arguments 3
Understanding Mailmerge 0
mailmerge execute 3
mail merge 5
Mail Merge Word Doc over SSL VPN 0

Top