IIF

  • Thread starter Thread starter Elainie
  • Start date Start date
E

Elainie

I have a field with yes/no, i would like to send an email if the field
= yes, i have done a macro to send the document to a member of staff,
but all the time, i want it sent when the field - yes only.

Any ideas?

Thanks

Elaine
 
I have a field with yes/no, i would like to send an email if the field
= yes, i have done a macro to send the document to a member of staff,
but all the time, i want it sent when the field - yes only.

Just what are you sending? A report? A programmatically generated EMail?

You can use a Query with a criterion of

True

or (equivalently)

-1

on the yes/no field in order to select only those records.

John W. Vinson [MVP]
 
Back
Top