copy paste contents of a excel worksheet into outlook email body

[bcdixit]

Hi,
I am new to vbscript. I wanted to copy contents of a excel sheet into the body of any email. Is there a way to do it.
I know how to attach the excel file but wanted to copy some contents inside the excel worksheet directly into the email body. the reason being, very few people open the attachment, but if I had the contents directly in the email body, then that would be more visible.
any help and direction would be appreciated.

-b

 

[ErrorLINE1CHAR1]

if your the one sending the email, it would probably save you time to just copy paste the tables/data you want into the email..

Devon
Intel Corp. (HF)

 

[bcdixit]

I am automating the process and want to send out the email sheet at a particular time of the day... so doing this manually is not efficient and does not meet the need