Send email message from Access 2003

[ishfady]

Hi

I have my clients email addresses in my Microsoft Access 2003 database.

Is there any way I can send email to my client, while I am in access database.

Please could you help me.

Many thank

 

[oharab]

The easiest way is the SendObject command:

docmd.SendObject acSendReport,"rptFoo",acFormatXLS,"bpo@example.com",,,"Foo Report","Here's the foo report"

If this isn't enough or doesn't work, post back.

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"

NoFX-The Decline
----------------------------------------------

 

[ssatech]

The way I send reports is by going to File on your toolbar.
File
Sent To
Mail recipient(as attachment)

You need to choose the format to send the report/message
e.g: Rich Text Format (RTF)
This will bring up your default email/ - Outlook Express/Microsoft Office Outlook

 

[pduncan]

Is there any way to reference an email address that is in a table - i.e. not hard coding it?



PDUNCAN - MEMPHIS, TN

When I die, I want to die like my grandfather-- who died peacefully in
his sleep. Not screaming like all the passengers in his car.