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

"Elainie" <Elaine.Macintyre@bsc.wales.nhs.ukwrote in message
news:1194522456.626681.124110@v29g2000prd.googlegr oups.com...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