Hi,

Is there a way to get the contents (few cell values) form
an Excel worksheet into a new outlook email throug VBA. I
don't want to attach the entire file.

Also, is there a way to get the file size (in KB) into
Excel sheet through VBA. I am already opening this text
file and copying the contents into the excel sheet through
VBA. I also want to get the file size.

Any help would be appreciated.

Thank you.