View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rpettis31 Rpettis31 is offline
external usenet poster
 
Posts: 49
Default 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.