File, SendTo, MailRecipient code

[MarvInBoise]

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!

 

[Ron de Bruin]

Hi MarvInBoise

See
http://www.rondebruin.nl/mail/folder3/mail2.htm

 

[MarvInBoise]

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.

 

[Ron de Bruin]

Copy the SheetToHTML function also in the module

 

[MarvInBoise]

Thanks, I saw that after I sent the response; I'll give it a shot! Thanks
for the help!