Send Report

[Guest]

I am running Access 97. Is there a way to use the 'SendObject' action to
send a report as a .pdf document? I have the Adobe Acrobat Distiller
installed on my machine and I am able to go to File-->Print-->Distiller and
create a .pdf document. I can then attach this to an email and send. I want
to be able to automate these steps and use a command button on a form. I am
creating a .pdf b/c when I send a report as .rtf, I loose all of my
formatting.

Either this, or is there another way to retain my report formatting when I
send a report using the 'SendObject' action?

 

[Terry]

Chuck,

This might do what you want. This library is used by us
and didn't cost a fortune.

http://ourworld.compuserve.com/homepages/attac-
cg/acgsoft.htm

It certainly works for creating individual pdf files and
although I don't use the email facility it looks like it
might automate your requirement.

HTH,

Terry