IIF

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Elainie - 09 Nov 2007 09:35 GMT

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

Reply to this Message

Marco - 09 Nov 2007 10:09 GMT

Hi.

If you try, iif ([e-mail] = yes; acion here)

Marco

> 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,
[quoted text clipped - 5 lines]
>
> Elaine

Reply to this Message

John W. Vinson - 09 Nov 2007 22:22 GMT

>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]

Reply to this Message