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

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

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 said:
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).
Click to expand...

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.
 
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!
Click to expand...

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.
 
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.
Click to expand...

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

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

Thanks!
 
Back
Top