I tried using the scheduler and I still got the dialog box from ME saying that it was unable to connect and that stopped the macro however I think I have just fixed the problem by inserting the log error and turning off the dialog box option. Testing it again now to make sure that it works through the errors. I appreaciate your help. Why isn't there just a checkbox that says something like run macro regardless of errors.