Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
email worksheet contents as text
I want to email the contents of a worksheet as if it had been printed, rather
than as an .xls attachment. I don't see anything like this capability in Ron de Bruin's sendmail tool. Is there some other tool available? The email client is Outlook Express. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
email worksheet contents as text
You can get a text v ersion of a range with this.
Dim datObj As DataObject ActiveSheet.UsedRange.Copy Set datObj = New DataObject datObj.GetFromClipboard If datObj.GetFormat(1) = True Then MsgBox datObj.GetText(1) End If NickHK "pwrichcreek" wrote in message ... I want to email the contents of a worksheet as if it had been printed, rather than as an .xls attachment. I don't see anything like this capability in Ron de Bruin's sendmail tool. Is there some other tool available? The email client is Outlook Express. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
email worksheet contents as text
With Outlook Express you can only do this
http://www.rondebruin.nl/mail/oebody.htm With Outlook you have more control Or better use CDO http://www.rondebruin.nl/cdo.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "pwrichcreek" wrote in message ... I want to email the contents of a worksheet as if it had been printed, rather than as an .xls attachment. I don't see anything like this capability in Ron de Bruin's sendmail tool. Is there some other tool available? The email client is Outlook Express. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple Export of worksheet contents to text-file. | Excel Programming | |||
How can i email the contents of a userform? | Excel Programming | |||
email worksheet as rich text | Excel Programming | |||
Email Range Contents | Excel Programming | |||
Read Contents of text File into worksheet | Excel Programming |