E-Mail from Access

[Guest]

Thanks for taking the time to read my question.

Currently I'm sending an e-mail message with this:

DoCmd.SendObject acSendNoObject, , acFormatRTF, Manager & ";" &
TheDefaultVendorEmail, TheDefaultCc, , TheEmailSubject, TheMessageText, -1

Is there a way I can change the "Reply" address, so that when the person
replies to the e-mail it actually goes to a different person?

Example: Person A wants a new pencil, they fill out the form in the database
and click the button to get approval. The e-mail goes to their manager. Now
9 times out of 10, even if I put a special bolded note to FORWARD the message
on to the next person, the managers will click REPLY. So to make life simple
I'd like to set the Reply to the next person... me.

Is this possible?

Brad

 

[j.mapson.nurick]

Hi Brad,

As far as I know you can't do this with DoCmd.SendObject. Instead
you'd have to write VBA code using the CDONTS or CDO libraries, or
automating the Outlook object model.

 

[Guest]

Thanks for the reply.

Well then I'll make the message to the managers bigger so they'll notice it
because I don't have enough skills to program that.

Thanks again,

Brad

 

[pietlinden]

Thanks for the reply.

Well then I'll make the message to the managers bigger so they'll notice it
because I don't have enough skills to program that.

Thanks again,

If you dig around here, there's an example of using CDONTS or CDOSYS.
Both are really easy. They encapsulate MAPI and deal with all the
complex parts for you. About the hardest part might be to create the
content of the message. And you can do that playing with string
variables.