Hi ,

I have a macro to create an image file and then attach it to a mail in outlook . The macro runs fine when I run it manually . However I have a requirement to send the same on a mail at 4 am and for that I have created a VBS file to run the same at 4 AM through Windows scheduler. However when it is run automatically at 4 AM the macro does not wok and mail is sent without an image. First I thought it was a issue with my Mail macro but the issue I found that the range when copy and pasted as graph and then exported it to image file is not working when runs automatically . Looks like the VBS scheduler runs faster and does not either copy the range or paste or fails to export. I tried to put Application.Wait also after copy and after paste but the problem is still there. The image file is created blank.

Can anyone help?