I am using macro to send reports saved in c:\Reports and then move the files to c:\Complete once its send out.
I was wondering if there is a way to auto run the macro if report files become available at C:\Reports folder. Or a macro code that can watch C:\Reports folder and then call the macro SendFilesEmail(). Thanks again.
I am using outlook 2010, win 7
I was wondering if there is a way to auto run the macro if report files become available at C:\Reports folder. Or a macro code that can watch C:\Reports folder and then call the macro SendFilesEmail(). Thanks again.
I am using outlook 2010, win 7