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