E-mail from Access

[LB Paul]

Does anyone know how to send reports from Access 2003 via
e-mail?

 

[Cheryl Fischer]

Check out the SendObject method. It is fully described in VBA Help.

 

[Alan Fisher]

-----Original Message-----
Does anyone know how to send reports from Access 2003 via
e-mail?
.
look up DoCmd.SendObject in the help files. There are a

lot of options to use with htis but it will let you send a
report via Outlook.

 

[Ragnar Midtskogen]

If you don't need to automate this, you can preview the report, then from
the File meny select Send To. This will open your default E-mail client and
allow to send the report as an attachment in several formats. The Snapshot
preserves the formatting, RTF does not..

Ragnar

 

[supoprt]

I am from the Access support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consulting

 

[Cheryl Fischer]

I do hope that you are offering your services at a price equal to that
charged here in the NewsGroup: Free.



--

Cheryl Fischer, MVP Microsoft Access

I am from the Access support department at

http://www.enterpriseprojectconsulting.com and we would be happy to assist
you in resolving your issue.

 

[Ragnar Midtskogen]

Right on Cheryl!

Ragnar

 

[Cheryl Fischer]

Thanks, Ragnar!
<G>