Microsoft Outlook Objects

[Moonshine]

Hi All

I have a piece of code that creates an email and sends it out to relevant people, using MS Access 2000. Problem is, i want to be able to add who its from, as we can send emails on other peoples behalf if we have access to their mailbox.

Looking in the Objects i cant seem to see one, is it at all possible?

I use this code to add a Recipient...

With objOutlookMsg
                          ' Add the To recipient(s) to the message.
                          Set objOutlookRecip = .Recipients.Add(rstExpiry.Fields![Social Worker])
                          objOutlookRecip.Type = olTo
End With

 

[freakazeud]

re:

Hi,
You can use the 'SentOnBehalfOf' property which is described in this article.
HTH
Good luck

 

[Moonshine]

Excellent, cheers for that it worked perfectly

Scott