Send payment slip to email in PDF format

[Chlaris]

Dear all,

I have a report called payment slip. Every employee get this report monthly.
I want my system can send this report to their email address in PDF format
and the PDF file is protected by password.
Please give me any guidance how to do it.
Thanks.

Chlaris

 

[Daniel Pineault]

In general I would suggest you use something like
http://www.lebans.com/reporttopdf.htm to convert your report to a PDF.
However, I do not believe (and I could be wrong) that it does not allow
password protection of the document (which really is a little overkill in
most cases). that said, if you absolutely require the password protection
then I would suggest you do some development usign PDFCreator. For a few
good articles on its use take a look at
http://www.excelguru.ca/taxonomy/term/1 , there you will find several
articles (you'll have to go through the various pages) and although written
using excel, it is very easy to use the same principles in Acccess.

Once you get your PDF code functional then you need only use the SendObject
method to e-mail it to your recipient(s).

 

[Chlaris]

Hello Daniel

How do I use SendObject method to send the PDF file to email ?
Can you give me the sample code ?
Thx.

Chlaris

 

[Tony Toews [MVP]]

How do I use SendObject method to send the PDF file to email ?
Can you give me the sample code ?

You can't send non Access object attachments using SendObject.

SendObject's twenty limitations
http://www.granite.ab.ca/access/email/sendobject.htm

You'll need to use an alternate method.
Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/