Sending e-mail

[CAM]

Hello,

I am using Access 2002 and I want to have the ability to print out a report
and if possible automatically e-mail to the manager. Now the manager will
not have MS Access. Is this possible? Any website to visit or tips will be
appreciated. Thank you in advance.

Cheers

 

[Stefan Hoffmann]

hi,

I am using Access 2002 and I want to have the ability to print out a
report and if possible automatically e-mail to the manager. Now the
manager will not have MS Access. Is this possible? Any website to
visit or tips will be appreciated. Thank you in advance.

Take a look at

http://www.peterssoftware.com/c_som.txt


mfG
--> stefan <--

 

[Stockwell43]

Hi Cam,

There are several ways to tackle this depending on your knowledge of VBA.
Mine is limited so I use work arounds. There are folks on this forum that
could suggest much better ways to accomplish this but I'll give you a couple
to start.

1. You can run your report, then in the toolbar export it (or Analyze) with
Word and this will dump it into a word document which will look exactly like
the access report so your manager does not need Access but will need MS Word.

2. You can create a macro to pull the report and package it up automatically
for you in an email and send it to your manager that way but again, he/she
will need MS Word.

As I said, you can probably get better suggestions but I use both of these
methods and have never had any issues.

Hope this helps!!!

 

[CAM]

Thanks Steve

Take a look at lebans.com. He has ConvertReportToPDF which converts an
Acceee report to a PDF file. You could use this then attach the PDF file
to an email and send it to your manager. Your manager would only need
Acrobat Reader. I've used it multiple times and it has worked very well.

Steve