View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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