| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File, SendTo, MailRecipient code
I need to code in Excel the keystrokes to do a File, SendTo, MailRecipient
and not as an attachment; I want to worksheet to be pasted into the message, the first choice on the SendTo line. Thanks! -- Marv Lusk Boise Corporation |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
File, SendTo, MailRecipient code
Hi MarvInBoise
See http://www.rondebruin.nl/mail/folder3/mail2.htm -- Regards Ron De Bruin http://www.rondebruin.nl "MarvInBoise" wrote in message ... I need to code in Excel the keystrokes to do a File, SendTo, MailRecipient and not as an attachment; I want to worksheet to be pasted into the message, the first choice on the SendTo line. Thanks! -- Marv Lusk Boise Corporation |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
File, SendTo, MailRecipient code
Thanks Ron, I think that's what I'm after, but the code bombs at the
..SheetToHTML line with a Sub or Function not defined; I see commenting out the line does not work, i.e., I get no attachment. We don't use HTML format in our emails (use RTF), so could that be the problem? Thank you, and thank you for your prompt reply to my original message. -- Marv Lusk Boise Corporation "MarvInBoise" wrote: I need to code in Excel the keystrokes to do a File, SendTo, MailRecipient and not as an attachment; I want to worksheet to be pasted into the message, the first choice on the SendTo line. Thanks! -- Marv Lusk Boise Corporation |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
File, SendTo, MailRecipient code
Copy the SheetToHTML function also in the module
-- Regards Ron De Bruin http://www.rondebruin.nl "MarvInBoise" wrote in message ... Thanks Ron, I think that's what I'm after, but the code bombs at the .SheetToHTML line with a Sub or Function not defined; I see commenting out the line does not work, i.e., I get no attachment. We don't use HTML format in our emails (use RTF), so could that be the problem? Thank you, and thank you for your prompt reply to my original message. -- Marv Lusk Boise Corporation "MarvInBoise" wrote: I need to code in Excel the keystrokes to do a File, SendTo, MailRecipient and not as an attachment; I want to worksheet to be pasted into the message, the first choice on the SendTo line. Thanks! -- Marv Lusk Boise Corporation |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
File, SendTo, MailRecipient code
Thanks, I saw that after I sent the response; I'll give it a shot! Thanks
for the help! -- Marv Lusk Boise Corporation "Ron de Bruin" wrote: Copy the SheetToHTML function also in the module -- Regards Ron De Bruin http://www.rondebruin.nl "MarvInBoise" wrote in message ... Thanks Ron, I think that's what I'm after, but the code bombs at the .SheetToHTML line with a Sub or Function not defined; I see commenting out the line does not work, i.e., I get no attachment. We don't use HTML format in our emails (use RTF), so could that be the problem? Thank you, and thank you for your prompt reply to my original message. -- Marv Lusk Boise Corporation "MarvInBoise" wrote: I need to code in Excel the keystrokes to do a File, SendTo, MailRecipient and not as an attachment; I want to worksheet to be pasted into the message, the first choice on the SendTo line. Thanks! -- Marv Lusk Boise Corporation |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FileSendTo in 2007 | Excel Discussion (Misc queries) | |||
| Sendto | Excel Discussion (Misc queries) | |||
| file/sendto/mailrecipient failure | Excel Discussion (Misc queries) | |||
| Code in one workbook to call code in another XL file | Excel Programming | |||
| Import VBA Code in Excel-File ? (Export VBA Code to file) | Excel Programming | |||
Hybrid Mode
