Send Email via access

[LeeTV]

Hi,
Access 2007.
I'm wanting to send email to select records via a different account, than
the default, via outlook.
i'm able to send the emails now, but it defaults to the current email
account (which is personal).
I could create a new windows account, set up a new outlook and run the DB
from this login, but that defeats the purpose of what i want to do.
Some emails have to come from biling email address, some emails are for
course registrations, and other emails are for certification emailing.. to
create all these different windows accounts would be quite a process.

in short: how do i send email via an account in outlook? (I think it has
something to do with ADODB and not the current DOA that i am using).
Any help will be much appreciated.
thanks
lee

 

[Douglas J. Steele]

Check the Access EMail FAQ that Tony Toews has at
http://www.granite.ab.ca/access/email.htm

For what it's worth, it's doubtful it has anything to do with ADO vs. DAO.
Those are methods of accessing data, not methods for sending e-mail. Not
only that, but there's no reason not to use DAO with Access 2007.

 

[Tony Toews [MVP]]

I'm wanting to send email to select records via a different account, than
the default, via outlook.

olItem.SentOnBehalfOfName = "(e-mail address removed)"

If you're running on Exchange you might need that account to allow
your Outlook account permission to do so. Or something weird like
that.

Tony