Change Routing Message...impossible to figure this one out

[Mike R.]

Hi!
Does anyone have a suggestion on how to change the standard routing message
that appears in Outlook when an Excel file is routed. This is the standard
message:

"The attached document has a routing slip. When you are done reviewing
this document, choose Next Routing Recipient from the Microsoft Excel Send To
menu on the File menu to return the document to its sender."

I do not user the 'Send to' menu, I have the user click a button that runs a
macro and then routes. I have tried everything...thanks,
Mike

 

[JNW]

can you post the code that emails the file?

 

[Mike R.]

Hi, here is the code...it basically set's a few routing fields and then opens
the routing dialog box.

Private Sub NewRouting()
Application.ScreenUpdating = False
ThisWorkbook.HasRoutingSlip = True
ThisWorkbook.RoutingSlip.Subject = Range("Q17")
Application.Dialogs(xlDialogRoutingSlip).Show
Application.ScreenUpdating = True
End Sub

thanks for your assistance.
Mike

 

[JNW]

Just to clarify...What do you want the email message to be (if anything at
all)? Do you really need the document routed or just sent?

JNW

 

[Mike R.]

yes, the document needs to be routed through several recipients who will
approve it. I would just like to change the canned message into something a
bit more personable such as "Please review the attached requistion form and
check to errors and then please approve." or something along those lines.
thanks for trying to help.
Mike

 

[JNW]

I can't see how to get rid of that message, but you could add your own before
it. Insert the following code after you line for the subject:
ThisWorkbook.RoutingSlip.Message = "Add your own message"

Hope that helps