E-mail alert based on a field value

Question

Hi,

I am relatively new to using SharePoint. I have a query on using a list.

I've created a list to track certain action items which has many custom columns two of which are "Raised By" and "Assigned To" and both are "Name" fields which are linked to email ids in my organization.

Now, the query is once I give entries to these two fields I would want to trigger e-mails to those IDs. I explored the option of "Alert Me" but that doesnt have provision to do this.

Could someone pls assist me with this?

Answer 1

I am not sure how to send emails in SharePoint but you can use SQL Server to send emails. I have a SharePoint project and all automatic notifications is done using SQL Server. 

May be one of the SharePoint expert can help you with it.