Hello
I have spun my wheels enough, and now need some help.
I have a reminder in outlook set for every Friday, to tell me to update a status file. I often just dismiss it and then get very off track and do not remember to update the file until the weekend. I want to put some code in the reminder event that recognizes this reminder and checks the excel file to make sure I actually updated it. I have everything figured out, with respect to checking the file.
I would now like to make the macro pause 10 minutes and check again. It will keep doing this and creat a popup to remind me every tem minutes, until I actually update the file. How can I make the code pause, before checking again? I have tried the Sleep method, but that freezes outlook completely. I need the code to pause, while allowing outlook to funtion normally. Is this possible? Should I be going for some other approach?
Thank you for any help!!
I have spun my wheels enough, and now need some help.
I have a reminder in outlook set for every Friday, to tell me to update a status file. I often just dismiss it and then get very off track and do not remember to update the file until the weekend. I want to put some code in the reminder event that recognizes this reminder and checks the excel file to make sure I actually updated it. I have everything figured out, with respect to checking the file.
I would now like to make the macro pause 10 minutes and check again. It will keep doing this and creat a popup to remind me every tem minutes, until I actually update the file. How can I make the code pause, before checking again? I have tried the Sleep method, but that freezes outlook completely. I need the code to pause, while allowing outlook to funtion normally. Is this possible? Should I be going for some other approach?
Thank you for any help!!
