Error with .Attachments.Add

[RyanMoran1990]

Hello,

This code that I'm using on a computer and its working PERFECTLY, but when I added this code to another computer, it stops adding the attachment to the email, what it does instead it displays the email without the attachment and it open the code showing me the line of ".Attachments.Add PdfFile" - indicating there is an error there, it's so weird how it works fine in a PC but it doesn't on another, any ideas?

Please help me figure this out! here is the code:

Please Login or Register  to view this content.

[sintek]

No Path Directory of PDF is specified here...

[RyanMoran1990]

how come it works in one PC and the other not? from what i understood, it uses the cache and then just deletes it, i dont want to save those files in my PC, i just want the code to send them and then just delete them.

what its supposed to do is to create a PDF from the active sheet and then send it by email, in one PC its working perfectly, the other does not attach, the macro stops, displays the email without the attachment and marks the line ".Attachments.Add" in yellow.

Please find sample attached

[RyanMoran1990]

Please check reply

[sintek]

Sometimes it saves to last used folder...Default folder
Just specify Path..., the code deletes the file after anyway...This way no errors will occur...

Try like such...

Please Login or Register  to view this content.

[RyanMoran1990]

Worked perfectly! thanks! <3

[sintek]

Glad I could assist...Happy Coding...