Mohan

For Outlook emails see these sites. If you can't find your answer there,
post back

www.dicks-clicks.com
www.rondebruin.nl

For file size, you can use the FileSystemObject. Set a reference to
Microsoft Scripting Runtime and you can get the size like this example

Sub test()

Dim fso As FileSystemObject
Dim FileSize As Double

Set fso = New FileSystemObject

FileSize = fso.GetFile("C:\Dick\CharityFormulas.txt").Size

MsgBox FileSize \ 1000

End Sub

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Mohan Manicks" wrote in message
...
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.