As you’ve learned, when setting up the stored procedure for a notification, you can enter in various data conditions to determine which customers receive the email notification. Similarly, you can also enter in various data conditions to determine which users receive a Cc or Bcc of the email notification.
To configure the Cc/Bcc recipients based on data conditions:
1. Open your notification event procedure in Microsoft SQL Server Management Studio or any other SQL script editor.
2. Navigate to the SELECT > /* Email Address */ section of the code and locate the [CC] and [BCC] sections similar to those highlighted in the screenshot below.
3. Next to the [CC] column, enter in the desired data conditions you want the system to consider when selecting the Cc recipients.
4. Next to the [Bcc] column, enter in the desired data conditions you want the system to consider when selecting the Bcc recipients.
Do NOT add any spaces after the semicolon, in between email addresses (e.g., email1@address.com;email2@address.com). If there is a space after the semicolon, in between email addresses, the notification will fail (e.g., email1@address.com; email2@address.com).
5. Save the file.