Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Sheet in Outlook | Excel Discussion (Misc queries) | |||
Excel Sheet in Outlook | Excel Discussion (Misc queries) | |||
Embedded excel sheet in outlook question??? | Excel Discussion (Misc queries) | |||
Import of Outlook Mails to Excel Sheet | Setting up and Configuration of Excel | |||
sending an excel sheet via outlook express | Excel Programming |