Dear experts,

I want to create a button which when clicked can directly mail to an email
address or Lotus Note address within the Company. I could not make the link
with a "Form" button but I could make the link with a "Control Toolbox"
button. However, without known reasons after a short time, the button was not
responding when clicked. Is my method of making the button correctly? Any
advice which I can achieve my expected result? Please kindly advise.

Thanks in advance.

For all Excel email questions get answers at Ron de Bruin's site.

Note the SendMail add-in available as well as the code.

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


Gord Dibben MS Excel MVP

On Thu, 19 Jun 2008 02:26:04 -0700, Freshman
wrote:

Dear experts,

I want to create a button which when clicked can directly mail to an email
address or Lotus Note address within the Company. I could not make the link
with a "Form" button but I could make the link with a "Control Toolbox"
button. However, without known reasons after a short time, the button was not
responding when clicked. Is my method of making the button correctly? Any
advice which I can achieve my expected result? Please kindly advise.

Thanks in advance.

Dear Gord,

I'll go through Ron's page. Thanks for your tips.

"Gord Dibben" wrote:

For all Excel email questions get answers at Ron de Bruin's site.

Note the SendMail add-in available as well as the code.

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


Gord Dibben MS Excel MVP

On Thu, 19 Jun 2008 02:26:04 -0700, Freshman
wrote:

Dear experts,

I want to create a button which when clicked can directly mail to an email
address or Lotus Note address within the Company. I could not make the link
with a "Form" button but I could make the link with a "Control Toolbox"
button. However, without known reasons after a short time, the button was not
responding when clicked. Is my method of making the button correctly? Any
advice which I can achieve my expected result? Please kindly advise.

Thanks in advance.