RESOLVED: Outlook From field

I am writing some Excel VBA code that will generate Emails in the Outlook Drafts folder.

It works fine, only I now want to be able to set the From field but I cannot see a Mailitem property that allows me to do it.

I would be very grateful for any ideas

Jon

I did some experimentation and I believe you need to use the SentOnBehalfOfName property...

I have permissions from different mailboxes where I work, and it worked for each that I tried