ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Email - Outmail - From (https://www.excelbanter.com/excel-programming/402304-email-outmail.html)

Richard

Email - Outmail - From
 
Hi

I am using the fantastic code as supplied by Ron De Bruin an extract of what
I am using is

With OutMail
.From = strfrm
.To = strto
.CC = strcc
.BCC = strbcc
.Subject = "subject"
.Body = strbody
.Attachments.Add "attached file"
'.Send
'or use
.Display

As my colleagues and I are able to send emails from ourselves, or any
department mailbox that we are permissioned to, I had thought/hoped that my
addition of .From would work wonders.

This is not working.

Is there a way to add the senders/from email address?

Thanks in advance
Richard

Dean

Email - Outmail - From
 
..From is not a valid argument... Outlook will attach the account email
address as from automatically. It will not show up on an email until it is
actually sent, so if you use the .display or .save arguments you will not see
a from on the email yet.

If I am not mistake, this is a security feature, it would be a bad thing if
someone could automate email to be sent on your behalf but make it look like
it is coming from somone else.

That is my knowledge, I have been working with Outlook and Excel for some
time and the one thing I still cannot get to work properly is to get excel to
open outlook if it is not currently opened.

I hope that helps.

Dean

"Richard" wrote:

Hi

I am using the fantastic code as supplied by Ron De Bruin an extract of what
I am using is

With OutMail
.From = strfrm
.To = strto
.CC = strcc
.BCC = strbcc
.Subject = "subject"
.Body = strbody
.Attachments.Add "attached file"
'.Send
'or use
.Display

As my colleagues and I are able to send emails from ourselves, or any
department mailbox that we are permissioned to, I had thought/hoped that my
addition of .From would work wonders.

This is not working.

Is there a way to add the senders/from email address?

Thanks in advance
Richard


Ron de Bruin

Email - Outmail - From
 
Read the tip page
http://www.rondebruin.nl/mail/tips2.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Richard" wrote in message ...
Hi

I am using the fantastic code as supplied by Ron De Bruin an extract of what
I am using is

With OutMail
.From = strfrm
.To = strto
.CC = strcc
.BCC = strbcc
.Subject = "subject"
.Body = strbody
.Attachments.Add "attached file"
'.Send
'or use
.Display

As my colleagues and I are able to send emails from ourselves, or any
department mailbox that we are permissioned to, I had thought/hoped that my
addition of .From would work wonders.

This is not working.

Is there a way to add the senders/from email address?

Thanks in advance
Richard



All times are GMT +1. The time now is 07:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com