Looking to make a macro that does basically what the subject title says.

I want to Range("A1:E19").Select and convert that selection to HTML and have
it e-mailed to (E-Mail Removed) as the body of the e-mail and not as an excel
attachment.

Any Help would be greatly appreciated.

I was using ActiveWorkbook.SendMail Recipients:="(E-Mail Removed)"

But like I said, that just e-mails the excel file as an attachment and I am
looking to convert to HTML and e-mail that as the body.

Thanks again!

hi ryanmhess

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ryanmhess" <(E-Mail Removed)> wrote in message news:211928B8-D502-42B5-9B4A-(E-Mail Removed)...
> Looking to make a macro that does basically what the subject title says.
>
> I want to Range("A1:E19").Select and convert that selection to HTML and have
> it e-mailed to (E-Mail Removed) as the body of the e-mail and not as an excel
> attachment.
>
> Any Help would be greatly appreciated.
>
> I was using ActiveWorkbook.SendMail Recipients:="(E-Mail Removed)"
>
> But like I said, that just e-mails the excel file as an attachment and I am
> looking to convert to HTML and e-mail that as the body.
>
> Thanks again!

I'm not too VB savy. A little unsure on how to go about and what you mean by
"Don't forget to copy the function RangetoHTML in the module."


"Ron de Bruin" wrote:

> hi ryanmhess
>
> See
> http://www.rondebruin.nl/mail/folder3/mail4.htm
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "ryanmhess" <(E-Mail Removed)> wrote in message news:211928B8-D502-42B5-9B4A-(E-Mail Removed)...
> > Looking to make a macro that does basically what the subject title says.
> >
> > I want to Range("A1:E19").Select and convert that selection to HTML and have
> > it e-mailed to (E-Mail Removed) as the body of the e-mail and not as an excel
> > attachment.
> >
> > Any Help would be greatly appreciated.
> >
> > I was using ActiveWorkbook.SendMail Recipients:="(E-Mail Removed)"
> >
> > But like I said, that just e-mails the excel file as an attachment and I am
> > looking to convert to HTML and e-mail that as the body.
> >
> > Thanks again!
>

Hi ryanmhess

Copy the macro and the function that you see on the page in a standard module
Look here : http://www.rondebruin.nl/code.htm

Download the Body example workbook from my site to test the code if you use Outlook.
http://www.rondebruin.nl/sendmail.htm

You can also use the add-in from my site



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ryanmhess" <(E-Mail Removed)> wrote in message news:923863C7-9EBC-46E4-A987-(E-Mail Removed)...
> I'm not too VB savy. A little unsure on how to go about and what you mean by
> "Don't forget to copy the function RangetoHTML in the module."
>
>
> "Ron de Bruin" wrote:
>
>> hi ryanmhess
>>
>> See
>> http://www.rondebruin.nl/mail/folder3/mail4.htm
>>
>> --
>>
>> Regards Ron de Bruin
>> http://www.rondebruin.nl/tips.htm
>>
>>
>> "ryanmhess" <(E-Mail Removed)> wrote in message news:211928B8-D502-42B5-9B4A-(E-Mail Removed)...
>> > Looking to make a macro that does basically what the subject title says.
>> >
>> > I want to Range("A1:E19").Select and convert that selection to HTML and have
>> > it e-mailed to (E-Mail Removed) as the body of the e-mail and not as an excel
>> > attachment.
>> >
>> > Any Help would be greatly appreciated.
>> >
>> > I was using ActiveWorkbook.SendMail Recipients:="(E-Mail Removed)"
>> >
>> > But like I said, that just e-mails the excel file as an attachment and I am
>> > looking to convert to HTML and e-mail that as the body.
>> >
>> > Thanks again!
>>

Thank you very much Ron. It's working great now!

"Ron de Bruin" wrote:

> Hi ryanmhess
>
> Copy the macro and the function that you see on the page in a standard module
> Look here : http://www.rondebruin.nl/code.htm
>
> Download the Body example workbook from my site to test the code if you use Outlook.
> http://www.rondebruin.nl/sendmail.htm
>
> You can also use the add-in from my site
>
>
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "ryanmhess" <(E-Mail Removed)> wrote in message news:923863C7-9EBC-46E4-A987-(E-Mail Removed)...
> > I'm not too VB savy. A little unsure on how to go about and what you mean by
> > "Don't forget to copy the function RangetoHTML in the module."
> >
> >
> > "Ron de Bruin" wrote:
> >
> >> hi ryanmhess
> >>
> >> See
> >> http://www.rondebruin.nl/mail/folder3/mail4.htm
> >>
> >> --
> >>
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl/tips.htm
> >>
> >>
> >> "ryanmhess" <(E-Mail Removed)> wrote in message news:211928B8-D502-42B5-9B4A-(E-Mail Removed)...
> >> > Looking to make a macro that does basically what the subject title says.
> >> >
> >> > I want to Range("A1:E19").Select and convert that selection to HTML and have
> >> > it e-mailed to (E-Mail Removed) as the body of the e-mail and not as an excel
> >> > attachment.
> >> >
> >> > Any Help would be greatly appreciated.
> >> >
> >> > I was using ActiveWorkbook.SendMail Recipients:="(E-Mail Removed)"
> >> >
> >> > But like I said, that just e-mails the excel file as an attachment and I am
> >> > looking to convert to HTML and e-mail that as the body.
> >> >
> >> > Thanks again!
> >>
>

Hi Ron - I've used your range to outlook code extensively in the past and it
works great thx a lot for that....i've got a slight issue with this
though....the code u have on your website converts the range to html....is
there an easy modification to the code to covert the code to enhanced image
(picture) instead of html...this would be immensly useful becos i want to
capture the currec formating available in excel 2007 (like red lights etc)...

any help would be much appreciated.

thx
Amit

"Ron de Bruin" wrote:

> Hi ryanmhess
>
> Copy the macro and the function that you see on the page in a standard module
> Look here : http://www.rondebruin.nl/code.htm
>
> Download the Body example workbook from my site to test the code if you use Outlook.
> http://www.rondebruin.nl/sendmail.htm
>
> You can also use the add-in from my site
>
>
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "ryanmhess" <(E-Mail Removed)> wrote in message news:923863C7-9EBC-46E4-A987-(E-Mail Removed)...
> > I'm not too VB savy. A little unsure on how to go about and what you mean by
> > "Don't forget to copy the function RangetoHTML in the module."
> >
> >
> > "Ron de Bruin" wrote:
> >
> >> hi ryanmhess
> >>
> >> See
> >> http://www.rondebruin.nl/mail/folder3/mail4.htm
> >>
> >> --
> >>
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl/tips.htm
> >>
> >>
> >> "ryanmhess" <(E-Mail Removed)> wrote in message news:211928B8-D502-42B5-9B4A-(E-Mail Removed)...
> >> > Looking to make a macro that does basically what the subject title says.
> >> >
> >> > I want to Range("A1:E19").Select and convert that selection to HTML and have
> >> > it e-mailed to (E-Mail Removed) as the body of the e-mail and not as an excel
> >> > attachment.
> >> >
> >> > Any Help would be greatly appreciated.
> >> >
> >> > I was using ActiveWorkbook.SendMail Recipients:="(E-Mail Removed)"
> >> >
> >> > But like I said, that just e-mails the excel file as an attachment and I am
> >> > looking to convert to HTML and e-mail that as the body.
> >> >
> >> > Thanks again!
> >>
>