How do I create a button on a worksheet for users to click on to send the
worksheet as an email to someone else. I want them to be able to click on a
button that will notify the office that their report is complete.

I have created a button and tried to record a macro but the email only sends
when I am recording the action, not when I click on the object later.

HELP

Everything you need to send emails from Excel can be found at Ron de Bruin's
site.

http://www.rondebruin.nl/sendmail.htm

Note the SendMail add-in which makes it all easy without writing your own
code.


Gord Dibben MS Excel MVP

On Thu, 22 Jan 2009 15:09:02 -0800, Julie
wrote:

How do I create a button on a worksheet for users to click on to send the
worksheet as an email to someone else. I want them to be able to click on a
button that will notify the office that their report is complete.

I have created a button and tried to record a macro but the email only sends
when I am recording the action, not when I click on the object later.

HELP

Thanks Gord,

this site is fantastic. But I am still a bit dumb on code. What is meant by
RangetoHTML and the first line that says: ' Don't forget to copy the function
RangetoHTML in the module.

I am not sure what to do.

"Gord Dibben" wrote:

Everything you need to send emails from Excel can be found at Ron de Bruin's
site.

http://www.rondebruin.nl/sendmail.htm

Note the SendMail add-in which makes it all easy without writing your own
code.


Gord Dibben MS Excel MVP

On Thu, 22 Jan 2009 15:09:02 -0800, Julie
wrote:

How do I create a button on a worksheet for users to click on to send the
worksheet as an email to someone else. I want them to be able to click on a
button that will notify the office that their report is complete.

I have created a button and tried to record a macro but the email only sends
when I am recording the action, not when I click on the object later.

HELP

Rangetohtml is a User Defined Function

That UDF must be copied from Ron's site to your workbook module along with
the macro.

I'm not sure which page you are on but the rangetohtml UDF is below the
macro.

Can you post the URL for the page you are on?

Here is a link with the UDF below the macro.

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

You would be much better of downloading the SendMail add-in IMO


Gord


On Thu, 22 Jan 2009 16:34:00 -0800, Julie
wrote:

Thanks Gord,

this site is fantastic. But I am still a bit dumb on code. What is meant by
RangetoHTML and the first line that says: ' Don't forget to copy the function
RangetoHTML in the module.

I am not sure what to do.

"Gord Dibben" wrote:

Everything you need to send emails from Excel can be found at Ron de Bruin's
site.

http://www.rondebruin.nl/sendmail.htm

Note the SendMail add-in which makes it all easy without writing your own
code.


Gord Dibben MS Excel MVP

On Thu, 22 Jan 2009 15:09:02 -0800, Julie
wrote:

How do I create a button on a worksheet for users to click on to send the
worksheet as an email to someone else. I want them to be able to click on a
button that will notify the office that their report is complete.

I have created a button and tried to record a macro but the email only sends
when I am recording the action, not when I click on the object later.

HELP