Routing Recipient

[Hoopster]

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?

 

[Ron de Bruin]

hi Hoopster

Is removed from in 2007

 

[Hoopster]

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]

Hi Hoopster

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

 

[Hoopster]

Ron,

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

 

[Ron de Bruin]

You are welcome

 

[Crewdawg]

Ron,

It seems you have some excellent code on your site.

I have heard that there is a way to prgramatically use the routing
functions, but did not see that in your add-ons or VBA. Have you experimented
with this at all. We need the routing function specifically because it tracks
the progress of the mail as it passes around.

Thanks,

Sean Harrington

 

[Ron de Bruin]

Hi Crewdawg

I try to use the old code we are able to use in Excel 2003 in Excel 2007 but it is not working anymore.
Sorry

 

[Rickie Lee]

Ron...you seem to have a good handle on excel document routing... bear with
me and my layman's knowledge while I try to discribe the issue I'm having....

How do you completely disconnect a previous routing slip from a routed doc
to allow someone else to create a new routing list like it's the first time a
doc has been routed?

We're using 2003 and we've started using routing process for our procedure
review and approval after a couple of false starts. Thought I had a handle
on it but still having some problems with documents that had previously
completed the routing process and subsequent saved with all changes accepted.
Original author/router had checked to route "one after another" , "return
when done", and "track status"

I took the doc and made subsequent changes, saved with a new doc title and
selected "file/send to" but doesn't let me treat as an original routing....

I must select route to next receipent or other receipent and majority of
previous routing receipients are no longer in functions or with company....
When select "other receipent" have to go thru a number of "check name"
boxes because says outlook doesn't recognize a certain name (that's no longer
with company and in address book) ... so I hit cancel and it goes to next
name it doesn't recognise and so on til it goes thru all the previous names 2
times....

At this point, routing box opens and I remove all the "To" names and select
"address" to add the actual folks I want to route to.

I make sure Route to selections "one afer another, return when done, track
status" blocks are checked and then select "route" to start the routing
process.

However, the routing status and final doc is being returned to the original
author, not me.

Is there a simple way to disconnect the original routing so I don't have to
go thru all these extra steps to route the doc anew and have it return to me
when finished? .... I also route word docs for review and approval, but I'm
usually the original author so don't have the issue on doc being returned.....