Thread: email macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Lobo[_2_] Lobo[_2_] is offline
external usenet poster
 
Posts: 12
Default 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