Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Emailing an Excel Worksheet
I am using this macro. Sub Hill() Range("A1").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Sheets("Sheet2").Select Range("A1").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=True End Sub I would like the macro to send the sheet in the body of the email as plain text. Is this possible ? Thank you in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Emailing an Excel Worksheet
hi
see this site http://www.rondebruin.nl/sendmail.htm also see this code. sheets("sheet1").activate Range("A1").Select Range("A1", Range("A1").End(xlToRight).End(xlDown)).Copy Sheets("sheet2").Activate Range("A1").PasteSpecial xlPasteValues does the same as yours. a bit cleaner. Regards FSt1 "carl" wrote: I am using this macro. Sub Hill() Range("A1").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Sheets("Sheet2").Select Range("A1").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=True End Sub I would like the macro to send the sheet in the body of the email as plain text. Is this possible ? Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enable emailing a worksheet in Excel? | Excel Worksheet Functions | |||
emailing excel worksheet with data protected? | New Users to Excel | |||
Emailing an excel worksheet | Excel Discussion (Misc queries) | |||
Emailing worksheet | Excel Discussion (Misc queries) | |||
Emailing an Excel worksheet | Excel Discussion (Misc queries) |