How do I set up email notificaion in Access 2003?

  • Thread starter Thread starter Analyst_42
  • Start date Start date
A

Analyst_42

I'm looking to have access email me with a record in my database if certain
criteria are met. Any suggestions as to how to set that up and manage the
different email addresses?
 
Hello,

There isn't anything "stock" in Access that will email you when certain
events take place. You would have to build something from scratch to perform
the function, store the email addresses, and then call it from whatever
procedure you want to run it if a certain scenario occurs. Or you could buy
a 3rd party product that already does it. I'm not 100% sure, but I think
FMS's Emailer product can do this (link below).

http://www.fmsinc.com/Products/Emailer/Access_Emailer_2007.asp

Hope this helps...
-DB
 
This works for me:

expression.SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject, MessageText, EditMessage, TemplateFile

e.g.

DoCmd.SendObject , , , strRecipientAddress,strCCAdress ,strBCCAddress , strSubject, strMessage, False

strxx are string variables that you set up with the text that you want.
 
Back
Top