Announcements
I was trying to add VBA code for sending email to notify our team each time when we create a new site.
Anyone can assist me by giving the code .
Thanks
*This post is locked for comments
I would consider creating a stored procedure that sends the email, and the vba passes the "Site ID" to the stored procedure when the User selects the "Send Email" button.
You would use the SQL Mail Profile in your stored procedure.
This way you can run all the normal connection vba code to call the sp.
You could even do this in a trigger on the IV40700 table, thereby the user doesn't need to push the button, making it automatic.
Mick
Thanks for your reply .. I have used Trigger on IV40700. Solved my issue.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Dan Liebl 2
