View Single Post
  #2  
Old June 30th 08, 02:25 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default 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
news
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.


Ads