[AccessD] OT: Automate PDF Creation

Hi All,

We currently have a web-based application, that I created, that we use to
manage employee vacation and personal time. I am using SQL Server 7.5 for
the BE. Every quarter we printout a report for every employee that gives
them a listing of all vacation time and personal time taken. It was
requested to add the ability to "click a button" and have the report sent
out via e-mail to those who have e-mail. Ideally it would send out a PDF
version of the report that we currently hand out.

My question is, how do I automate the creation of PDFs? This would need to
take place on the server side and the server would be responsible for
sending out the e-mails, I think.

Anyone have any suggestions to get me started?

JR




This electronic transmission is strictly confidential to TNCO, Inc. and
intended solely for the addressee. It may contain information which is
covered by legal, professional, or other privileges. If you are not the
intended addressee, or someone authorized by the intended addressee to
receive transmissions on behalf of the addressee, you must not retain,
disclose in any form, copy, or take any action in reliance on this
transmission. If you have received this transmission in error, please notify
the sender as soon as possible and destroy this message. While TNCO, Inc.
uses virus protection, the recipient should check this email and any
attachments for the presence of viruses. TNCO, Inc. accepts no liability for
any damage caused by any virus transmitted by this email.