This topic is locked

Printing Word Documents

5/27/2005 9:41:08 AM
ASPRunnerPro General questions
Alberto author

Hello Sergey and everybody,
We are in a need to print documents using data from the screen just like the merge but most of the time would be only for 1 record or a small group of them.

If anybody have solved or have an idea for this kind of need would be great.
Example:

Base document: A standard letter written in MS Word.

Fields to fill: Name and address.

Origin of the data: Either from the screen or database but should be ease to select the record to print like clicking a couple of things.
I try using the merge but it seems that is really complex to select the record to print and is too far or complex for a regular user.
Thanks for the help

Pfeiffer 5/27/2005

Hello Sergey and everybody,

We are in a need to print documents using data from the screen just like the merge but most of the time would be only for 1 record or a small group of them.

If anybody have solved or have an idea for this kind of need would be great.
Example:

Base document: A standard letter written in MS Word.

Fields to fill: Name and address.

Origin of the data: Either from the screen or database but should be ease to select the record to print like clicking a couple of things.
I try using the merge but it seems that is really complex to select the record to print and is too far or complex for a regular user.
Thanks for the help



Hello,
I needed 3 weeks to solve this problem and at least did the following :

a) The SERVER creates the Winword documents using a series-Document.

Its a litte bit difficult, because Winword was not created for Server Application.

The ISS-User on server must have admin privileges !! You can't start a macro

on server, because Winword denies. So you have to do it in ASP.
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=4572&image=1&table=forumreplies' class='bbc_emoticon' alt='B)' /> ASP-Runner creates a csv. File, then opens Winword and forces winword

to bild the document using the csv-File.

if only one record is marked, only one document will be created. But you can

also mark several recods, you will get then one winword-document with

several pages.
c) My Winword-documents are saved on a SQL-Server, so the user can select the

winword-document he wants to connect with the marked records.
I hope it helps.
uwe Pfeiffer

Alberto author 5/27/2005

Thank you very much Pfeiffer, I understand what you're saying, I already have spent few days thinking, reading and trying things to get it done. I appreciate your answer.
I am also using SQLServer 2000 and MS Windows 2003 Server but have no much experience with this kind of programming. I will try what you have done and I hope to come out with something that works and the users like.
By the way I was reading about it in Microsoft's web page that may be related to how you solved it. How to automate Word to perform a client-side Mail Merge using XML from SQL Server
I don't know yet, but I will continue trying counting with what I have now until I get it done. Thanks
Anyways if somebody else has another kind of solution or more information about it and likes to share it with us is really appreciated.

Thanks again.