Send Object Macro IIF Statement Formula Problem!

J

Juan

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.
 
S

Steve Schapel

Juan,

Something like this...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need a formula 1
Condition for Send object 1
send object using a maco--filter report 1
Send Object Macro, Need Help!! 3
string together IIf statements into one text box? 3
send spreadsheet macro 3
"SEND OBJECT COMMAND ins't available now" 0
IIF statement 4

Top