I often program MS Access to automatically send E-mails
using docmd.sendobject. I normally do it with a Button.
It activates the MS Outlook of the current user and
prepares or prepares/automatically sends an E-mail from
the current user.
the code has this command:
DoCmd.SendObject acSendNoObject, , ,
EmailAddress, , , "Your Personal Information / Votre
Information Personnel", tombstone, False
Emailaddress is a string variable, "Your Personal..." is
the subject, and tombstone is string a variable
representing a the body of the E-amil.
I never heard of a 99% event procedure before. Try an
AfterUpdate Event for starters.
Kevin
-----Original Message-----
I am trying to create an automatic email in access 2002.
The email will have to be generated when a field would
reach say 99% and only sent once. I think I want to use
the DoCmd.SendObject Method but am having some
difficulties in doing so. Also, I would like to know who
the email would be sent from ie. (the user that is
currently logged in and made the field change to 99%. I
have been thrown into this and haven't worked with
Programming Visual Basic for about 3 years back in
college. Any suggestions or help would be greatly
appreciated. Thanks!
