Ron,

Thank you so very much. Worked like a charm.....

"Ron de Bruin" wrote:

Hi Hoopster

See the code examples on this site
http://www.rondebruin.nl/sendmail.htm

--

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


"Hoopster" wrote in message ...
Ron,

Then please, what is my best course of action. Can I hard code an
E-Mail address to each Command Button? Is there another way to do the same
thing in 2007?

"Ron de Bruin" wrote:

hi Hoopster

Is removed from in 2007

--

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


"Hoopster" wrote in message ...
Hello,

When we were using Office 2000, I had a Workbook that we were using as
a Change Request Form. In short, anytime we wanted to make a change in our
process, we would start one of these forms. I had buttons set up that would
when clicked would send the Workbook on to the next Routing Recipient.
We have since upgraded to Office 2007 and these buttons no longer work.
I'm not sure if it don't reconize the Macro or just what is going on. I can't
even find in Excell 2007, a way to set up an E-Mail routing. Where should I
look and what do I look at next?