Outlook Message Formatting - thru Excel VBA
hi - I'm trying to put a command button in excel that will open a new mail in
outlook 2007 with a bunch of email addresses picked up from a rangeg of cells. I have been able to achieve this, but need some guidance on putting text in the message body. the intention is to have a table (or template) created in the mail and then let the user fill the table up and send it. any help would be much appreciated. |
Outlook Message Formatting - thru Excel VBA
The best way to do that would be to use HTML encoding and to create the
table in the email HTMLBody property using HTML code to design the table. If the table already exists then you could attach the template as an embedded attachment, which would put it into the HTMLBody of the email. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options. http://www.slovaktech.com/products.htm "amit" wrote in message ... hi - I'm trying to put a command button in excel that will open a new mail in outlook 2007 with a bunch of email addresses picked up from a rangeg of cells. I have been able to achieve this, but need some guidance on putting text in the message body. the intention is to have a table (or template) created in the mail and then let the user fill the table up and send it. any help would be much appreciated. |
All times are GMT +1. The time now is 05:09 PM. |
Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com