Send Object Macro IIF Statement Formula Problem!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I've created a macro that automatically sends me an email everytime i open
the main form. Now what i want is to only receive this email when:

1. there are records in the query
2. only on the 5th, 10th, 15, 20th, and
25th of each month.

what formula would i have to type in the condition column???

thanks in advance for any adivice.
 
Juan,

Something like this...

DCount("*","YourQuery")>0 And Day(Date()) Mod 5 = 0
 
Back
Top