Create e-Payment Slip

[Chlaris]

Dear all,

I'm developing payroll application. For montly payroll slip, I want the
report can be delivered to each employee email in pdf file as attachment.
Please give me some information what should I do.
Thanks.

Chlarissa

 

[Tom van Stiphout]

On Fri, 9 Jan 2009 20:07:38 +0700, "Chlaris"

DoCmd.SendObject can send out emails in PDF format. You would need to
write some VBA and DAO code to loop over a recordset with employees
and call this for each employee.

-Tom.
Microsoft Access MVP

 

[Mark Andrews]

Isn't that only in Access 2007? If using an older version you can use
http://www.lebans.com/reporttopdf.htm
to create the pdf and search for articles on how to send emails from access
with attachments.
use a third party SMTP dll if the built-in access methods for email don't
work for you.

Also you could use a pdf printer driver to create the pdf files (most allow
you to control them from the registry
or some other method). My fav is win2pdf.

I still sell a batch reporting tool that uses a central queue for reporting.
I wrote that one about 8 years ago so it's getting kinda outdated.
Hoping to update it soon (once I get some free time).

HTH,
Mark
RPT Software
http://www.rptsoftware.com

 

[Chlaris]

Hello Tom & Mark,

Thanks for your answer.

Chlaris