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

Hi MarvInBoise

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


--
Regards Ron De Bruin
http://www.rondebruin.nl



"MarvInBoise" <MarvInBoise@discussions.microsoft.com> wrote in message news:9DD7B97C-C8C2-40E3-808B-D7B76CA1E834@microsoft.com...
>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

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

Copy the SheetToHTML function also in the module


--
Regards Ron De Bruin
http://www.rondebruin.nl



"MarvInBoise" <MarvInBoise@discussions.microsoft.com> wrote in message news:88993A19-543C-4BEF-9705-CDE656C7B9BD@microsoft.com...
> 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

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" <MarvInBoise@discussions.microsoft.com> wrote in message news:88993A19-543C-4BEF-9705-CDE656C7B9BD@microsoft.com...
> > 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
>
>
>