Send Object - email but change the from field

[sjbowe]

I am generating reports in Access 2002 and emailing a series of reports to various people at our sites.

I am using -

DoCmd.SendObject acSendReport, "rptdata", "RichTextFormat(*.rtf)", rs("Email_Address"), "", "", "email subject", "email message body", False

I want to the email sent to come from a different email address than the person logged into the system. ie if I run it, I want the email to be sent from a generic "accounts@ingeus.com.au" rather than my own email address.

Outlook lets you adjust this by changing the From field but I dont believe that the send object will allow you to utilise this field.

Can anyone advise?

 

[SeeThru]

The only way to do it is to link to the outlook (tools>references when in code mode) and use create an outlook message - that way you can define from ,to attachments, importance etc.


I can post some code if you need it...