CDO with Attachment Help!

Hi Guys!

So im using CDO to automate emailing some excel files i have updated everyday.

These files get saved with tomorrows date - and everytime i try to attach a file it says cannot find specific file.. now if i specify the name exactly then it works however i want this to run even when i am not here so i need vba to recognize tomorrows date and im not sure why its not working as im using the same method to save the file name with tomorrows date?

Please Login or Register  to view this content.

i get error - the system cannot find the specified file.

Any ideas? ~ have tried using autoit to send CDO email but couldnt get it working either

Try adding this below your CDO_Mail_Object.AddAttachment and compare to your file name.
Make sure your immediate window is showing.
It might show you something you couldnt see before.
I find the Local, Watch and Immediate windows to be very helpful for debugging.

Please Login or Register  to view this content.

Hi Jason,

not too sure how i use this? doesnt do anything for me lol

Haha is your immediate window showing?
Open up the VBA editor and go to View->Immediate Window
Or I think Ctrl+G also works.
When you do that, the debug.print line will "print" the variable in the immediate window