With VBA, I sent out emails with a script. Now I want to be able to add
a three-column table to the message, which currently is
copy-and-pasted. The number of the rows of the tables vary.

I do not want to save the table to a new file, because it is small
table and there are several dozens of emails I need to mail out.

I may not be able to put the tables in the "email sheet" on which I
have email addresses, subject, etc., because when I copy the table from
my data sheet, and paste it in a cell on the "email sheet", it occupies
three cells.

What is the best way to email a table? Please advise.

Have you looked at Ron de Bruin's site.
Example Code for sending mail from Excel
http://www.rondebruin.nl/sendmail.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Who I Am" wrote in message oups.com...
With VBA, I sent out emails with a script. Now I want to be able to add
a three-column table to the message, which currently is
copy-and-pasted. The number of the rows of the tables vary.

I do not want to save the table to a new file, because it is small
table and there are several dozens of emails I need to mail out.

I may not be able to put the tables in the "email sheet" on which I
have email addresses, subject, etc., because when I copy the table from
my data sheet, and paste it in a cell on the "email sheet", it occupies
three cells.

What is the best way to email a table? Please advise.