Changing From: emailing with Excel...

[adimax]

Hello all. Looking to add the finishing touch to this code I snagged
off a post someone made in this group (I apologize for not being able
to give credit to the author; this was 3-4 months ago). It's working
great for what I need it to do, but I wanted to change the From: field/
property in Outlook (ver 2003).

I went in and added the 'From = ' field and the VBA code seems fine
with it, but when I run a test email to myself using the code either
with .Display or .Send, my own email address on the Exchange server
I'm on shows up as the sender/if I reply.

From my experience with Outlook in the past, I thought it was this
From field that dictated who the receiver would reply to... am I

mistaken? And if not, how can I change it? Or how can I essentially
send from email address A to B, but have B return it to C if they
reply.

(C will not be using Excel or Outlook, just whatever client they
happen to have... Eudora... Gmail... etc)

/code snippet

On Error Resume Next
With OutMail
.To = "" & TextBox1 & ""
.From = "(e-mail address removed)"
.CC = ""
.BCC = ""
.Subject = "Test"

.Body = "Hello!"

'.Attachments.Add wb2.FullName
'You can add other files also like this
'.Attachments.Add ("C:\test.txt")
'.Send
.Display
End With

/end code

Thanks in advance!

Benjamin

 

[Ron de Bruin]

hi Benjamin

See this page
http://www.rondebruin.nl/mail/tips2.htm


Change sender name and reply address

If you want to change the sender name and reply address add this code line

'The receiver can see the original mail address in the properties if he want
..SentOnBehalfOfName = """SenderName"" <[email protected]>"

 

[adimax]

Ron,

You are absolutely amazing. That page had exactly what I needed and SO
much more. Thank you so, so, so very much.

And is that a world record for most timely response?

Benjamin