Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel contents to Outlook email
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel contents to Outlook email
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel contents to Outlook email
Mohan Manicks wrote:
I also want to get the file size. Simplest way for file size is FileSize = FileLen("C:\MyDir\Myfile.xls") Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel to form email in outlook | Excel Worksheet Functions | |||
Create Outlook email from Excel | Excel Discussion (Misc queries) | |||
Excel and Email/Outlook | Excel Worksheet Functions | |||
How do I get excel to create an email using Outlook? | Excel Discussion (Misc queries) | |||
open outlook email from excel? | Excel Programming |