specify "from" in email from access

[Guest]

Is there a way to specify a "From" email in Access? I want to send this from
a specific mailbox. I am using Outlook that does not support seperate
identities.
This is the code I'm currently using.
DoCmd.SendObject acSendTable, "Form email", acFormatXLS, Email_address, , ,
"Form email", "Form attached." & Chr(13) & "Thank you." & Chr(13) & Chr(13) &
"No Reply Required", False

Any help you can provide is greatly appreciated!
-Jen

 

[Guest]

Hi Jennyrd,

I'm pretty sure the sendobject functionality works on your default mailbox.
One way that *MIGHT* work as a workaround is to have another mail client (eg:
Outlook Express) set up as your default mail handler that has the "from
address" you are after set as the default email account in there.

I have not tried this, but it makes sense in theory (as a workaround
solution). I guess the other way would be to get some other mail sending
code to use that does allow specification of a from address, eg: the
System.web.mail object in VB.NET.

Damian.