Automatically email

[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

 

[Mark Phillipson]

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/

 

[Tom Ross]

How would you format the strToWhom for a Microsoft Mail address?

 

[Mark Phillipson]

It is just a string - the email address

How would you format the strToWhom for a Microsoft Mail address?