is it sending the email because there are no entries displaying Over Due?

Matthew

No
For example there are 3 Action Items when one is "Done" and the other 2 are "Over Due"
It sends an email to all 3 of them


Thanks

Can you send me the file?

[email protected]

Cheers

Matthew

Sent

There is a problem with the email address you wrote
i get Returned Mail: Error During Delivery

Please write your email address again

Thanks

The email address is correct, I guess there must be some kind of firewall protection.

Try

[email protected]

Hi Danny

Thanks for sending the email, change the Cell.Find statement as follows.

replace LookIn:=xlFormulas
with LookIn:=xlValues

cheers

Matthew

Can anybody help on the similar topic, how to send the email using Lotus Notes.

Thanks!

Just an FYI...

If I place response.write myArray(i) & "<br>" above the "sub" syntax, it shows the two states I seleted.

If I place response.write myArray(i) & "<br>" AFTER the sub sytax, it writes only ONE state. I need ALL states to get emails.

Any clue??