Hello. Outlook 2003.
Automating sending an email with VBA I can't see the 'From' field to send and email on behalf
of someone?
Just occurred to me that perhaps this is a security setting? (For obvious reasons). Is this the case?
Andy.
Send From with VBA
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Send From with VBA
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- Administrator
- Posts: 78471
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Send From with VBA
Yep, it's security. You can set the SentOnBehalfOfName property of a MailItem:
Code: Select all
Dim objMessage As MailItem
Set objMessage = Application.CreateItem(olMailItem)
...
objMessage.SentOnBehalfOfName = "Big Brother"
...
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Send From with VBA
Thank you. Where does this appear in the received email pl?HansV wrote:Yep, it's security. You can set the SentOnBehalfOfName property of a MailItem:
Code: Select all
Dim objMessage As MailItem Set objMessage = Application.CreateItem(olMailItem) ... objMessage.SentOnBehalfOfName = "Big Brother" ...
Regards, Andy.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- Administrator
- Posts: 78471
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Send From with VBA
This is the effect if I send an e-mail to myself with you as sender:
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Send From with VBA
@Hans Thank you.
(Seems sneaky )
(Seems sneaky )
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.