Email on Yes

I have a field that has Yes/No in it, I would like if it is a "Yes" to
send an auto email to a certain member of staff with a form attachment
on it.

I have tried a module that says if "Yes" docmd.sendobject therefore to
send a macro with the full details of the person in it.

But it keep chucking up error messages......

Has anyone got any more ideas of how to do this.

Thanks a mill

Elaine

Re: Email on Yes

"Elainie" wrote in message
news:1194522456.626681.124110@v29g2000prd.googlegroups.com.. .
>I have a field that has Yes/No in it, I would like if it is a "Yes" to
> send an auto email to a certain member of staff with a form attachment
> on it.
>
> I have tried a module that says if "Yes" docmd.sendobject therefore to
> send a macro with the full details of the person in it.
>
> But it keep chucking up error messages......

What specific error message(s) is it "chucking up"? It's much easier to
assist in remote debugging if we know a little more than "something went
wrong".

Larry Linson
Microsoft Access MVP