Sending Email - different reply-to address



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


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]



Thanks Ron that code worked great....

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

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

I tried adding: .Item.sentOnBehalfOfName = """MySenderName ""

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


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


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.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question