Table from Excel into Outlook
 

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

Table from Excel into Outlook
 

Hi iambalrog

See my site for example code
http://www.rondebruin.nl/sendmail.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"iambalrog" wrote in message
...

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 copies
it into an email in ms outlook after some text.

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

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

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


--
iambalrog
------------------------------------------------------------------------
iambalrog's Profile: http://www.excelforum.com/member.php...o&userid=26977
View this thread: http://www.excelforum.com/showthread...hreadid=570742