I have a table in excel using cells say A10:F20 on Sheet1.

I want to be able to make a macro that picks up this table, and copie
it into an email in ms outlook after some text.

i.e.
"Dear All
please find attached this months business report. The summary detai
is as such:
xxxINSERT TABLE HERExxx

Please do not hesitate to contact me if i can be of any mor
assistance.
Thanks
Tim"

The recipitents of the email will be standard, and the location of th
file would be standard too. The macro would need to compose the email
fill in the recipitents/subject line, add in the table, and sen
itself.
I know you guys can help!!!

--
iambalro
-----------------------------------------------------------------------
iambalrog's Profile: http://www.excelforum.com/member.php...fo&userid=2697
View this thread: http://www.excelforum.com/showthread.php?threadid=57074