Send query to mail merge doc

[696796]

Hi experts,

Any ideas how i can send a query through so that it powers a mail merge document in ms word?

Any help much apreciated guys and gals,

Al

 

[PGoRule]

send a query through

Can you provide some details?

Sharing the best from my side...

--Prashant--

 

[696796]

Ok sure,

Sometimes a mail merge is powered by a query that could be stored in your access database. This is a static query which cannot be changed and is bound to the document.

Now what i was thinking was if i built the sql statement in vb.net, and open the mailmerge document sending through the query to the document so that it can be used as the datasource...

Cheers for the help

 

[ThatRickGuy]

We have a good number of mail merge letters here. We have a system that pulls relevant data, formats, and processes it, then spits out a delimited text file. The mail merge template points at that text file. We have a few luxeries though, all of our users had an H: drive, so we can run all of the text files out to a processing folder on that drive and we don't have to worry about attaching the source at run time.

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.