Hello,
This is my first post.
I want to automatically send an email from Access 2010 (runtime on Server 2008) when certain data is changed on a form without utilizing an installed email client.
Would someone kindly assist with code for an Event Procedure to do this? I am not proficient with VB. Here are some specifics:
1. Select reciepients based on field in the changed record (there are not many alternatives - might be hard coded)
2. Use another field in record for the email title
3. Hard code sender address, message, SMTP server name, user & password (server requires authentication).
4. Simple text format, no attachments.
Thanks in advance.
This is my first post.
I want to automatically send an email from Access 2010 (runtime on Server 2008) when certain data is changed on a form without utilizing an installed email client.
Would someone kindly assist with code for an Event Procedure to do this? I am not proficient with VB. Here are some specifics:
1. Select reciepients based on field in the changed record (there are not many alternatives - might be hard coded)
2. Use another field in record for the email title
3. Hard code sender address, message, SMTP server name, user & password (server requires authentication).
4. Simple text format, no attachments.
Thanks in advance.
