hi everyone,

What i need to do is fairly simple but i can't manage to do it...

What i need is a Macro that can do the following:

i want a serie of button called "coaching" on row h4 to h1000, all the button are identical and do the same purpose.

When we click on the button i want the name to change from "coaching" to "email sent", and i want outlook to open with a email adress in the "to" field, and want the subject of the email to be "agent that need coaching".

So each time i fill a row, if i need a coaching to be done, i click the coaching button and it open up outlook with a "to" and a "subject", and i can then, manually finish the email.

So a quick resume:
series of button that fit individually in cell h4 to h1000, called coaching
when i click it change to email sent
And open outlook with a "to" email and "subject" prefilled.

Anyone can help?