I am using CDO.Message and everything is running fine until I try to add an attachment. I think that the problem is that the webserver running this code does not have permission to the resource where the attachment is stored, even though the users attempting to use this do!
You can see that I am not permissions expert!
IIS is set to Windows Authentication, no anonymous.
strSubject = "test"
strBody = "Blah!"
Set objMail = CreateObject("CDO.Message")
objMail.From = "firstname.lastname@example.org"
objMail.ReplyTo = "email@example.com"
objMail.Subject = strSubject
objMail.TextBody = strBody
objMail.AddAttachment = "\\server\Files\test.doc"
Set objMail = Nothing
For example, I can access \\server\Files\test.doc directly but cannot run this code without an Access Denied error... Just to clarify, If I set the attachment to be a file on the webserver, it works fine.
Please can someone help me?