Correct format for CDO AddAttachment for UNC path

Question

CDO works fine in Access VBA for me except when I try to use UNC paths for the attachments. According to MSDN documentation on CDO, AddAttachment should allow UNC paths. Here's what I think should work, but doesn't:

msg1.AddAttachment "\\serv.dom.local\path with spacesh1\file.xls"

It works perfectly fine if I use "C:...". What's the correct format?

The error I get is -2147024894 (80070002). "The system cannot find the file specified"

UPDATE: I gave up and created (or copied) the file to my local C drive rather than continue to fool with this.

Answer 1

Have you tried to just use the server name.

i.e.

msg1.AddAttachment "\\servername\path with spacesh1\file.xls"

Answer 2

Does the user that runs the COM ActiveX has permissions to access that share?

Answer 3

The UNC format should be: \\servername\sharename\path\filename

Whichever user runs the program would have to have permissions for the sharename