excel sheet to outlook

  • Thread starter Thread starter Rpettis31
  • Start date Start date
R

Rpettis31

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2010 Sendmail .Display works, but not .Send --- Please help 2
try to email with vba, but more than one sheet and convert to pdf 9
include date and time in email subject line 2
Macro for Email - Sending to email addresses in cell 1
Macro sending sheet with not working hyperlink 0
BCC global distribution list 2
Outlook VB not working 5
filename in "Subject" in email 13

Back
Top