Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert to HTML and e-mail selection as the body of the e-mail.
Looking to make a macro that does basically what the subject title says.
I want to Range("A1:E19").Select and convert that selection to HTML and have it e-mailed to as the body of the e-mail and not as an excel attachment. Any Help would be greatly appreciated. I was using ActiveWorkbook.SendMail " But like I said, that just e-mails the excel file as an attachment and I am looking to convert to HTML and e-mail that as the body. Thanks again! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert to HTML and e-mail selection as the body of the e-mail.
hi ryanmhess
See http://www.rondebruin.nl/mail/folder3/mail4.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ryanmhess" wrote in message ... Looking to make a macro that does basically what the subject title says. I want to Range("A1:E19").Select and convert that selection to HTML and have it e-mailed to as the body of the e-mail and not as an excel attachment. Any Help would be greatly appreciated. I was using ActiveWorkbook.SendMail " But like I said, that just e-mails the excel file as an attachment and I am looking to convert to HTML and e-mail that as the body. Thanks again! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert to HTML and e-mail selection as the body of the e-mail
I'm not too VB savy. A little unsure on how to go about and what you mean by
"Don't forget to copy the function RangetoHTML in the module." "Ron de Bruin" wrote: hi ryanmhess See http://www.rondebruin.nl/mail/folder3/mail4.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ryanmhess" wrote in message ... Looking to make a macro that does basically what the subject title says. I want to Range("A1:E19").Select and convert that selection to HTML and have it e-mailed to as the body of the e-mail and not as an excel attachment. Any Help would be greatly appreciated. I was using ActiveWorkbook.SendMail " But like I said, that just e-mails the excel file as an attachment and I am looking to convert to HTML and e-mail that as the body. Thanks again! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert to HTML and e-mail selection as the body of the e-mail
Hi ryanmhess
Copy the macro and the function that you see on the page in a standard module Look here : http://www.rondebruin.nl/code.htm Download the Body example workbook from my site to test the code if you use Outlook. http://www.rondebruin.nl/sendmail.htm You can also use the add-in from my site -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ryanmhess" wrote in message ... I'm not too VB savy. A little unsure on how to go about and what you mean by "Don't forget to copy the function RangetoHTML in the module." "Ron de Bruin" wrote: hi ryanmhess See http://www.rondebruin.nl/mail/folder3/mail4.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ryanmhess" wrote in message ... Looking to make a macro that does basically what the subject title says. I want to Range("A1:E19").Select and convert that selection to HTML and have it e-mailed to as the body of the e-mail and not as an excel attachment. Any Help would be greatly appreciated. I was using ActiveWorkbook.SendMail " But like I said, that just e-mails the excel file as an attachment and I am looking to convert to HTML and e-mail that as the body. Thanks again! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert to HTML and e-mail selection as the body of the e-mail
Thank you very much Ron. It's working great now!
"Ron de Bruin" wrote: Hi ryanmhess Copy the macro and the function that you see on the page in a standard module Look here : http://www.rondebruin.nl/code.htm Download the Body example workbook from my site to test the code if you use Outlook. http://www.rondebruin.nl/sendmail.htm You can also use the add-in from my site -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ryanmhess" wrote in message ... I'm not too VB savy. A little unsure on how to go about and what you mean by "Don't forget to copy the function RangetoHTML in the module." "Ron de Bruin" wrote: hi ryanmhess See http://www.rondebruin.nl/mail/folder3/mail4.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ryanmhess" wrote in message ... Looking to make a macro that does basically what the subject title says. I want to Range("A1:E19").Select and convert that selection to HTML and have it e-mailed to as the body of the e-mail and not as an excel attachment. Any Help would be greatly appreciated. I was using ActiveWorkbook.SendMail " But like I said, that just e-mails the excel file as an attachment and I am looking to convert to HTML and e-mail that as the body. Thanks again! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert to HTML and e-mail selection as the body of the e-mail
Hi Ron - I've used your range to outlook code extensively in the past and it
works great thx a lot for that....i've got a slight issue with this though....the code u have on your website converts the range to html....is there an easy modification to the code to covert the code to enhanced image (picture) instead of html...this would be immensly useful becos i want to capture the currec formating available in excel 2007 (like red lights etc)... any help would be much appreciated. thx Amit "Ron de Bruin" wrote: Hi ryanmhess Copy the macro and the function that you see on the page in a standard module Look here : http://www.rondebruin.nl/code.htm Download the Body example workbook from my site to test the code if you use Outlook. http://www.rondebruin.nl/sendmail.htm You can also use the add-in from my site -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ryanmhess" wrote in message ... I'm not too VB savy. A little unsure on how to go about and what you mean by "Don't forget to copy the function RangetoHTML in the module." "Ron de Bruin" wrote: hi ryanmhess See http://www.rondebruin.nl/mail/folder3/mail4.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ryanmhess" wrote in message ... Looking to make a macro that does basically what the subject title says. I want to Range("A1:E19").Select and convert that selection to HTML and have it e-mailed to as the body of the e-mail and not as an excel attachment. Any Help would be greatly appreciated. I was using ActiveWorkbook.SendMail " But like I said, that just e-mails the excel file as an attachment and I am looking to convert to HTML and e-mail that as the body. Thanks again! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Body | Excel Programming | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Mail as body | Excel Discussion (Misc queries) | |||
body of mail and sheet. | Excel Programming | |||
Mail Worksheet as (html) message body | Excel Programming |