I have some VBA running behind a command button that when clicked takes some details from a query and sends an email containing this info, it also adds an attachment to the email. The attachment is stored locally. I cant see any reason why but this has now stopped working. The error message i get is:
Run-time error'-2147024894 (80070002)2:
Cannot find this file. Verify the path and file name are correct.
The error occurs on this line of code:
Set objOutlookAttach = .Attachments.Add("C:\test.doc")
Does anyone know why Access has suddenly stopped being able to find the file?