View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rogue Swan Rogue Swan is offline
external usenet poster
 
Posts: 1
Default sendmail works in excel 2002 but not 2000

that is a solution for xl2002 which is not the problem (the mapix line
is on both machines).

I should have also mentioned that the error occurs here (after sending
the explicitly named email, which actually gets sent):

.SendMail ActiveSheet.Range("g4"), "P.O. " &
ActiveSheet.Range("C6") & " has been approved and sent
to " &
ActiveSheet.Range("C8")

.SendMail ActiveSheet.Range("G8"), "Purchase Order
Confirmation "
.ChangeFileAccess xlReadOnly
'Kill .FullName

End With
End Sub

*** Sent via Developersdex http://www.developersdex.com ***