Automatically email

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Good morning!

I am wondering if anyone knows how to set the after update
event of a combo box to send an email based on the new
value.

Specifically, i have a combobox which displays a
requisitioners name for a certain part. If a user changes
the requisitioner (i.e. hands off responsibility) i want
an email to be sent to the new requisitioner informing
them of the change. The email address is in a table whose
PK correlates direcly to the bound column in the combo box

Thanks in advance,
Michael
 
Hi,

You could use the SendObject method of the DoCmd Object i.e.

strToWhom= "(e-mail address removed)"
strTitle="Name Changed"
strMessage= "Please note a name has changed..."
DoCmd.SendObject , , , strToWhom, , , strTitle, strMessage, False

HTH

--

Cheers
Mark

Free Access/Office Add-Ins at:
http://mphillipson.users.btopenworld.com/
 
Back
Top