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" wrote:

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." wrote:

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" wrote:

can you post the code that emails the file?

"Mike R." wrote:

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