| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Routing Message...impossible to figure this one out
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change Routing Message...impossible to figure this one out
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change Routing Message...impossible to figure this one out
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change Routing Message...impossible to figure this one out
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change Routing Message...impossible to figure this one out
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change Routing Message...impossible to figure this one out
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 "Mike R." wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Routing Slips in Excel 2007 - where is "Next Routing Recipient ?" | Excel Discussion (Misc queries) | |||
| Change the canned Routing message | Excel Programming | |||
| Change Routing Message in Outlook when Excel File is Routed | Excel Programming | |||
| Routing - macro to open routing dialog and then stop | Excel Programming | |||
| impossible to change the activecell??? | Excel Programming | |||
Hybrid Mode
