View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MarvInBoise MarvInBoise is offline
external usenet poster
 
Posts: 39
Default 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