J
jlnebo
I used the .HasRoutingSlip Property in a macro for Excel 2003. after
upgrading to Excel 2007 the .HasRoutingSlip macro give me the message:
Run-time error '1004':
Method 'HasRoutingSlip' of object '_Workbook' failed
Can anyone tell me what in might need to do differently in Excel 2007 to get
this macro to work or if there is a different option to use in order to use a
macro to send an email to several people?
The code I used was:
' With ThisWorkbook
'
' .HasRoutingSlip = True
' With .RoutingSlip
' .Delivery = xlAllAtOnce
' .Recipients = Array("(e-mail address removed)", "(e-mail address removed)")
' .Subject = "Install-Change-Remove Form"
' .Message = ActiveWorkbook.name + (" Is waiting at
\\server\share\Folder\Subfolder")
' .ReturnWhenDone = False
' End With
' .Route
' End With
upgrading to Excel 2007 the .HasRoutingSlip macro give me the message:
Run-time error '1004':
Method 'HasRoutingSlip' of object '_Workbook' failed
Can anyone tell me what in might need to do differently in Excel 2007 to get
this macro to work or if there is a different option to use in order to use a
macro to send an email to several people?
The code I used was:
' With ThisWorkbook
'
' .HasRoutingSlip = True
' With .RoutingSlip
' .Delivery = xlAllAtOnce
' .Recipients = Array("(e-mail address removed)", "(e-mail address removed)")
' .Subject = "Install-Change-Remove Form"
' .Message = ActiveWorkbook.name + (" Is waiting at
\\server\share\Folder\Subfolder")
' .ReturnWhenDone = False
' End With
' .Route
' End With