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.
"amit" <amit@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.