View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike R. Mike R. is offline
external usenet poster
 
Posts: 59
Default Macro to active Menu Command of FileSend ToRouting Recipent

Hello,
I am very determined to get the routing to work. I am trying to eliminate
the need for the user to go to FileSend ToRouting Recipent by create a
macro to do this. I under the code to get to open the routing dialog box:

Application.Dialogs(xlDialogRoutingSlip).Show

The problem is that if I use this, it must skip something that links to the
users outlook. When I run the above code, it opens another dialog box that
asks the user to choose a profile. This will totally confuse my users. Is
there a way to have a macro do the commands of FileSend ToRouting Recipent?
The macro recorder does not for this...

Please help...I would welcome any suggestions to make this work. Thank you,
Mike