using macro to email report on exact day and time

[1-acxi-1]

Hello,

I'm sure this has already been asked before but I'm trying to use a
macro to send a report (any object) from the database on the last
business day of the month. Any help would be greatly appreciated. I
have the macro created with the 'send object' action but i don't know
what condition to place before it to email on the exact date.

Thanks!

 

[Steve Schapel]

1-acxi-1,

Condition would be like this...


Date()=DateSerial(Year(Date()),Month(Date())+1,0)-Weekday(DateSerial(Year(Date()),Month(Date())+1,0),2)+5

 

[1-acxi-1]

thank you!