Using CC and BCC in Notification Services
I'm trying to set CC (CarbonCoby) and BCC properties of an email notification. The SMTP protocol element of my ADF looks like this:
<Protocol>
<ProtocolName>SMTP</ProtocolName>
<Fields>
<Field>
<FieldName>Subject</FieldName>
<SqlExpression>SubjectText</SqlExpression>
</Field>
<Field>
<FieldName>From</FieldName>
<SqlExpression>FromAddress</SqlExpression>
</Field>
<Field>
<FieldName>To</FieldName>
<SqlExpression>DeviceAddress</SqlExpression>
</Field>
<Field>
<FieldName>Priority</FieldName>
<SqlExpression>N'Normal'</SqlExpression>
</Field>
<Field>
<!-- Send email in 'text' or 'html' format here.-->
<FieldName>BodyFormat</FieldName>
<SqlExpression>N'html'</SqlExpression>
</Field>
<Field>
<FieldName>CC</FieldName>
<SqlExpression>CCAddress</SqlExpression>
</Field>
<Field>
<FieldName>BCC</FieldName>
<SqlExpression>BCCAddress</SqlExpression>
</Field>
</Fields>
The EventRule:
<
EventRules><
EventRule><
RuleName>SendNotificationRule</RuleName><
Action>-- Insert the Notifications into the MSClubAlert table, this matches Events to Subscriptions
INSERT INTO MSClubAlerts(SubscriberId, DeviceName, SubscriberLocale, CCAddress, BCCAddress, Notification_ID, NotificationBody, Date, SubjectText, FromAddress)
SELECT s.SubscriberId, s.DeviceName, s.SubscriberLocale, s.CCAddress, s.BCCAddress, e.Notification_ID, e.NotificationBody, e.Date, e.SubjectText, e.FromAddress
FROM MSClubEventData e, AlertBatch s
WHERE e.Notification_ID = s.Notification_ID;
</
Action><
ActionTimeout>PT30M</ActionTimeout><
EventClassName>MSClubEventData</EventClassName></
EventRule>Although the mail gets delivered to the TO recipient the CC and BCCs don't receive it. I think its a problem with the way I've named them in the <FieldName> tags above, but can't find much info in the help.
Any thoughts?
Thanks in advance.
