Hi Rpettis31

If you read the information on the page you can read that you also must copy the function
RangetoHTML to the module

See
http://www.rondebruin.nl/mail/folder3/mail2.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Rpettis31" wrote in message ...
I keep getting the sub or function not defined on this line.
With OutMail
.To = "rep"
.CC = ""
.BCC = ""
.Subject = "This is a test"
.HTMLBody = RangetoHTML(rng) **This line**
.send

I am able to send the email or text but I can not get the sheet to send.