E-mail Alerts are not being sent to users

It's possible that e-mail alerts aren't being sent to users in a certain environment.  This can be caused by incorrect Alert Settings and can also be caused by using an incompatible version of Microsoft Exchange.
1. Go to Administration > E-mail Alerts and click 'Edit alert settings' under Tasks.  
2. Verify the 'SQL Server Database Mail Profile' and the 'Selected database' are configured correctly.  It's important for the mail profile to be set to public. If you get errors running the following script you need to make a change:

EXECUTE AS LOGIN = 'XXXXXXXXXX'  

exec dbo.USP_ALERT_SEND
@MAIL_RECIPIENTS=N'xxxxxxxx@blackbaud.com',
@MAIL_SUBJECT=N'Test',
@MAIL_BODY=N'Test 123456',
@MAIL_BODYFORMAT=N'TEXT',@MAIL_IMPORTANCE=N'Normal'

Execute as login needs to be machine name, change mail recipients to who you wish to receive mail.

3. Verify that the version of Microsoft Exchange being used is compatible for the version of Blackbaud CRM being used. Blackbaud CRM 3.0 and 4.0 are only compatible with Microsoft Exchange 2010 and 2013. Office 365 is not supported at this time, nor are lower versions of Exchange lower than 2010.

 

Environment

 Blackbaud CRM

Was this article helpful?