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.

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" <amit.DeleteThis@discussions.microsoft.com> wrote in message
news:DB8C0AE6-CD78-4E0F-8B03-D1C8B57C2E2C@microsoft.com...
> 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.