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
<(E-Mail Removed)> 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
> <(E-Mail Removed)> 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.
>
>