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

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

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

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

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