barkley
Board Regular
- Joined
- Mar 31, 2003
- Messages
- 148
Hi
I am successfully using sendmail commands on almost every PC in the company, besides one.
I used the simple code below to test the PC, but it dislikes the SendMail line. The code works fine on my machine but not on the other.
I have checked the Outlook 10.0 Library but cannot work out what else could affect this.
I've run it with both outlook open and closed, and if closed it fires up Outlook, so it knows exactly what to do, I get the warning that a program is sending mail, but after clicking Yes, the runtime error occurs.
"Runtime Error 1004" - on the SendMail Line
Does anyone have any other ideas what could be causing this? I am baffled. Is there a setting in Outlook that needs to be set? Or am I missing a second Object Library on this machine?
Thanks for reading.
I am successfully using sendmail commands on almost every PC in the company, besides one.
I used the simple code below to test the PC, but it dislikes the SendMail line. The code works fine on my machine but not on the other.
I have checked the Outlook 10.0 Library but cannot work out what else could affect this.
I've run it with both outlook open and closed, and if closed it fires up Outlook, so it knows exactly what to do, I get the warning that a program is sending mail, but after clicking Yes, the runtime error occurs.
Code:
Sub SimpleSend()
Sheets("sheet1").Copy
ActiveWorkbook.SendMail Recipients:="email_address@hotmail.com", Subject:="Testing"
'Still no body text!
'BUT THIS ONE SENDS WITHOUT REVIEWING THE MESSAGE (Can be good or bad)
End Sub
"Runtime Error 1004" - on the SendMail Line
Does anyone have any other ideas what could be causing this? I am baffled. Is there a setting in Outlook that needs to be set? Or am I missing a second Object Library on this machine?
Thanks for reading.