Connecting Tech Pros Worldwide Forums | Help | Site Map

Email on Yes

Elainie
Guest
 
Posts: n/a
#1: Nov 8 '07
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


Larry Linson
Guest
 
Posts: n/a
#2: Nov 8 '07

re: Email on Yes



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


Closed Thread