Attach PDF located in special folders into email

[kingkyle2005]

In this I have already accomplished creating the PDF, and saving in a specific folder across multiple platforms. The trouble I am having is attaching ANY sort of attachment. I have declared names and references, and none work.

I have tried to remove and change all parts of GetObject("WScript.Shell").SpecialFolders, but get errors before the process is complete when I do that. How can I Re-access the desktop across multiple windows versions, in order to attach the file that was just created to an email that otherwise successfully generates?

Please Login or Register  to view this content.

[jaslake]

I don't know about your Code in general but for this line of Code I believe you need to eliminate the trailing backslash. Change this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

[kingkyle2005]

No bueno @jaslake. Tried that prior, and after your post. Thanks for helping though!

I think it has something to do with GetObject("WScript.Shell").SpecialFolders("Desktop")

I tried replacing the above line with

Please Login or Register  to view this content.

and the attachment was successful.

However, this will not provide the link to "Desktop\Program\Reports\" for multiple users, and Environ will not work either due to multiple excel & windows versions.

[kingkyle2005]

Figured it out, not sure why it works now, but it does.

Please Login or Register  to view this content.

[jaslake]

Glad you got it sorted...