Changing the "From" field when sending emails via an Access form

[dannyrblock]

We send out surveys to clients and keep track of them in Access. A form has
been set up to send out various surveys to email addresses in an Access
table. The form works just fine, with two bugs: (1) we have to change the
"From" field for each of several hundred emails (to "Quality Control"), and
(2) then hit "Send". Can this be accomplished in vba?

 

[dannyrblock]

After looking through the Online Community questions, I should note that what
we need to be able to do is use a different Outlook email account to send
from. The person who generates the emails logs in to the network under
his/her own name, but is also the "Quality Control" department, which has
it's own email account.

Does that help? Any possibilities?

Thanks!

Dan

 

[Rick Brandt]

After looking through the Online Community questions, I should note
that what we need to be able to do is use a different Outlook email
account to send from. The person who generates the emails logs in to
the network under his/her own name, but is also the "Quality Control"
department, which has it's own email account.

Does that help? Any possibilities?

You can do this if you use OLE Automation code against the Outlook library,
CDO, or any other compatible messaging library that exposes the FROM field
of the outgoing message.

You cannot do it using the built in SendObject command.

 

[dannyrblock]

Thanks, Rick. The obvious next question is....how? Any good reference
places I can look? I'm not the world's greatest vba developer (just really
learning, unfortunately, although I've used Access for some time & through
various iterations...).

Dan

 

[Rick Brandt]

Thanks, Rick. The obvious next question is....how? Any good
reference places I can look? I'm not the world's greatest vba
developer (just really learning, unfortunately, although I've used
Access for some time & through various iterations...).

Dan

Sample code here...

http://www.mvps.org/access/modules/mdl0019.htm

 

[dannyrblock]

Rick, you're awesome! Thanks for the link; I'll let you know if I can get it
to work for our application.

Dan