Sending E-mail from an account that is not logged in

I am currently writing a macro in Access 2007 with VBA. Is there a way
to send e-mail from an exchange account that is not currently logged
into Outlook? I’m able to send e-mail using my account, but other
users will be running the macro and I’d like to have it so that the
mail sends from a reporting e-mail account (without having them log
directly into that account).

Thanks!

"Steve" wrote in message
...
I am currently writing a macro in Access 2007 with VBA. Is there a way
to send e-mail from an exchange account that is not currently logged
into Outlook? I’m able to send e-mail using my account, but other
users will be running the macro and I’d like to have it so that the
mail sends from a reporting e-mail account (without having them log
directly into that account).

I'm not sure it does what you want, but look up SendUsingAccount in the
Outlook object model. From the online help: "The SendUsingAccount property
can be used to specify the account that should be used to send the MailItem
when the Send method is called." I presume the logged-in account must have
"send-as" permission for that Exchange account.

On Mar 16, 4:02*pm, Steve wrote:
I am currently writing a macro in Access 2007 with VBA. Is there a way
to send e-mail from an exchange account that is not currently logged
into Outlook? I’m able to send e-mail using my account, but other
users will be running the macro and I’d like to have it so that the
mail sends from a reporting e-mail account (without having them log
directly into that account).

Thanks!

What if you use the CDOSys library? I think you can specify a
username and password as part of the parameters, so you can send e-
mail from any account for which you have the password.

On Mar 17, 12:55*am, "
wrote:
On Mar 16, 4:02*pm, Steve wrote:

I am currently writing a macro in Access 2007 with VBA. Is there a way
to send e-mail from an exchange account that is not currently logged
into Outlook? I’m able to send e-mail using my account, but other
users will be running the macro and I’d like to have it so that the
mail sends from a reporting e-mail account (without having them log
directly into that account).

Thanks!

What if you use the CDOSys library? *I think you can specify a
username and password as part of the parameters, so you can send e-
mail from any account for which you have the password.

Where can I find documentation for the CDOSys library? I've found some
examples, but still don't really have a grasp on it.

On Mar 23, 3:49*pm, Steve wrote:
On Mar 17, 12:55*am, "
wrote:

On Mar 16, 4:02*pm, Steve wrote:

I am currently writing a macro in Access 2007 with VBA. Is there a way
to send e-mail from an exchange account that is not currently logged
into Outlook? I’m able to send e-mail using my account, but other
users will be running the macro and I’d like to have it so that the
mail sends from a reporting e-mail account (without having them log
directly into that account).

Thanks!

What if you use the CDOSys library? *I think you can specify a
username and password as part of the parameters, so you can send e-
mail from any account for which you have the password.

Where can I find documentation for the CDOSys library? I've found some
examples, but still don't really have a grasp on it.

Never mind, I figured out what was getting me. The CDO method works
great!

Thanks!