excel sheet to outlook
 

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.

excel sheet to outlook
 

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.