using macro to email report on exact day and time

  • Thread starter Thread starter 1-acxi-1
  • Start date Start date
1

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!
 
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
 
Back
Top