Connecting Tech Pros Worldwide Help | Site Map

Email on Yes

Elainie
Guest
 
Posts: n/a
#1: November 8th, 2007, 11:55 AM
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: November 8th, 2007, 03:35 PM

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
help with auto email on my website ibid answers 5 November 13th, 2007 06:14 PM
.NET 2.0: Sending email on local domain to local exchange 2K server Jim in Arizona answers 8 January 24th, 2006 05:45 PM
EMAIL on Win98 VenuGopal answers 5 November 17th, 2005 05:49 AM
CSS does not work on HTML email on Modzilla Mail Ukiharappa answers 10 July 20th, 2005 05:16 PM