How to send email when changes are made to asset tracking table?

[ittechguy]

I have an asset tracking table which keeps track of communications equipment as well as the cabinet/room/building they're located in and also the customers who are the point of contact for that room.

Whenever we make changes to the network (remove one or more piece of equipment, install one or more piece of equipment) we're required to send an email out to all of the network engineers letting them know that a change to the network has been made.

I'm trying to build a way for that to be more automated. It would be great if I could make changes in the database, and then hit a button for an email to popup in Outlook already filled out and ready to be sent. How exactly is this done?

I think the challenging part would be building a form to add new records and remove old records. I think I might need an audit log for this purpose because I would need to know what information needed to be in the email.

[zmbd]

Very simple emails can be sent using DocmdSendObject, an example is found here https://bytes.com/topic/access/answe...ok#post3742915
This can be easily modified to pull from a table of emails as shown in this thread: https://bytes.com/topic/access/answe...rt#post3764587 by ADezii and he has a more flexible solution further down that will handle more complex situations that involve application automation as show in our insights article Application Automation


You will find numerous threads here dealing with various aspects of how to handle sending emails from within Access...
here's a wide open search result on our site:
https://bytes.com/searchresults.php?...ail&gsc.page=1