email macro
hm
So what you are saying is.. somewhere in the workbook... have a cell that contains the macro name and the date it was last run.. and then have an auto code... to check
If the date it was last run = today then dont run it again. (do not launch the EmailRoutine sub
If the date it was last run is not equal to today then run it again. (launch the EmailRoutine sub
Hm this would also require me to somehow have the cell containing the last run date change when i run the EmailRoutine sub...ahhh
Sounds simple (somewhat).. but i have no idea where to start... or what to do.
does anyone have any ideas
|