RangetoHTML from different sender

[dshafique]

Hi guys, I am trying to use Range to HTML function but i want the email to be sent from another account I have on my server. however, Whenever I run it, it sends from my main account. anyway around this?
thanks

On Error Resume Next
    With OutMail
        .From = "contact@coachnil.com"
        .To = "Daoud.shafique@roboticapro.com"
        .CC = ""
        .BCC = ""
        .Subject = "This is the Subject line"
        .HTMLBody = RangetoHTML(rng)
        .Display

 

[Domenic]

Have a look at the following article from Ron de Bruin . . .

Use the mail account you want in your mail macro

Hope this helps!

 

[dshafique]

Thank you so much for your support. Sendonbehalf was exactly what I needed

thank you