By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 911 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

Automatically send email after update of a field

P: 2
Hi There

I am working on an Access database and looking to write some code to do the following.

I have a combo box and when it is updated i need it to send an email automatically to a pacific email address, I know there are ways to do this but i dont want the user to have to click anything after this.

Can anyone help me with this?

Thanks

Steve
Jan 10 '08 #1
Share this Question
Share on Google+
4 Replies


ollyb303
P: 74
Hey Steve,

You should be able to write your email procedure in the combo box's AfterUpdate event.

Hope that helps,

Olly
Jan 10 '08 #2

P: 2
Hey Steve,

You should be able to write your email procedure in the combo box's AfterUpdate event.

Hope that helps,

Olly
Hi Olly

Do you know the coding that i would need, i have some coding but it promps the user to click send mail which is not ideal.

Thanks

Steve
Jan 10 '08 #3

P: 45
What email system are you using? Complete auto generated emails from Outlook were stopped by Microsoft some time ago. I remember there were some work-arounds but I didn't bother. That's why I keep a copy of Outlook 2000 on my mass mailer. However with XMLHTTP requests you can now get around that issue by sending your request directly to the Exchange server.
Jan 10 '08 #4

ollyb303
P: 74
Steve,

I've had the same problem myself with Outlook. I currently use Lotus Notes and I have code that works fine with that. As above, what are you using?

Cheers,

Olly
Jan 15 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.