Export data to letters

[Andrew]

Hi Experts,

I have a DB containing many records of customers' info. How can I pull these
data to the MS Word mail merge letters containing the header (name, address,
etc) and contents (description 1, 2, 3,...) page by page per record? Thanks
a lot.

Andrew

 

[Ray Costanzo [MVP]]

Is ASP really the right technology to use for this? Since Word has the
functionality all built into it, why not use Word to do it? Word is
programmable, if you'd like to automate it that way.

Ray at work

 

[Andrew]

Because I want the users to specify the records output to the Word template,
and click somewhere(a button) to be prompted download or display Word format
on webpage.

 

[Stephanie Stowe]

Because I want the users to specify the records output to the Word template,
and click somewhere(a button) to be prompted download or display Word format
on webpage.

Does it have to be Word? Or just nice looking? My personal preference is to
let Word be a really nice desktop app, and use other things for client /
server and web apps. If it were me, I would use Crystal or Appligent's
StampPDF.

In theory, I can imaging you could create Word docs using automation,
perhaps within VB dll, on the server then push them down to the client or
provide a link to the completed doc. But I have no experience, so that is
the limit of what I will say. Sorry.

 

[Andrew]

Yes, you are on the right track. I was thinking about using mail merge
feature of Word.