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
thanks
VBA Code:
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