Oulook Email routing via Excel

K

kh4130

We have an excel sheet in our office that uses VB code to route the document
to other users via Outlook. However, I can not get this function to work in
Excel 2007.

I recieve the error:
Run-time error '1004':
Method 'HasRoutingSlip' of object '_Workbook' failed.

Has this feature been removed from Office 2007? I believe it has from what I
have read but I have not head a definite answer yet.
 
H

herringk

Upon more research I round the "Send to" functionality in Excel '07 was
removed b/c it was not a commonly used funtion.

http://technet2.microsoft.com/Offic...213f-47d5-809c-aba9331ae0331033.mspx?mfr=true

"Send to Routing Recipient
Description: The Send to Routing Recipient feature is removed.

Reason for change: Removal of this low-use feature from the user interface
improves the user experience.
"


If anyone knows a work around with Excel '07 please let me know.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Routing Slip Error in Excel 2007 0
Routing slip in Excel 2007 0
.HasRoutingSlip 0
How do I set up a routing slip in Office Excel 2007? 0
Routing Slips in Excel 2007 - where is "Next Routing Recipient ?" 4
Excel opening from Email link 0
Problem removing sharing from workbook via Macro 3
Word 2013 DDE merge to Excel file 0

Top