Sending Email - different reply-to address

[PWS]

Apologies for cross posting, please understand I did not know which
group would be best.

I have the following code in Excel which creates an EMail

Dim olApp As Object
Dim olMail As Object
Set olApp = CreateObject("Outlook.application")
Set olMail = olApp.CreateItem(0)

With olMail
.To = sRecipientList
.Subject = "FI Secondary Bond Trading Daily P&L Report"
.HTMLBody = RangetoHTML(Range("nTableData"))
.Display
End With

Set olMail = Nothing
Set olApp = Nothing


What I would like is to either send this Email from another Account,
so that the replies all come back to that Email account

OR

Set the reply-to address on the Email to that other Email address
where all repleis will be sent to.

I would apprecaite anyone's insight and code [smile]

PWS

 

[Ron de Bruin]

Hi PWS

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

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]>"

 

[PWS]

Thanks Ron that code worked great....

Flushed with that success I was asked to do a similar thing with this
code...

With ActiveSheet.MailEnvelope
.Item.BCC = sRecipientList (an array of Email addresses)
.Item.Subject = "Subject"
End With

I tried adding: .Item.sentOnBehalfOfName = """MySenderName ""
<MySenderEmailAddress>"

I could not find any info on the properties of the MailEnvelope, can
you suggest what I need to do in this instance.

 

[Ron de Bruin]

Hi PWS

Never Try this and there is also nothing in the Help.
I never use MailEnvelope myself but I will try to find a answer for you

 

[PWS]

I used this technique because it was so simple... until I wanted to
send from another account.

Using the mailEnvelope technique I am able to send worksheets with
images on them without having to go through the HTMl route. It works
really well just seems totally undocumented.

I appreciate your offer to try to find an answer.

PWS