How to send notification to multiple email ID's of a same person.

Ashwini8 · ‎03-16-2021

Hi All,

We have a requirement that when a notification is sent, suppose a user has 2 mail id's. then it should send the notification to both the email address.

In user form we have below fields, suppose alternative email id field is not empty then it should send notification to both the email id's. Please suggest some solution to implement this.

Thanks

Rogers Cadenhe1 · ‎03-17-2021

Create a business rule on sys_email before insert that adds each recipient's alternate email address to the Recipients field.

(function executeRule(current, previous /*null when async*/) {

	// get the current recipient(s)
	var emailTo = current.recipients.split(',');
	for (var i = 0; i < emailTo.length; i++) {
		// look for a user matching a recipient email address
		var userRec = new GlideRecord('sys_user');
		userRec.addEncodedQuery('email=' + emailTo[i] + '^u_alternate_emailISNOTEMPTY');
		userRec.query();
		if (userRec.next()) {
			// found one, so add their alternate email
			emailTo.push(userRec.u_alternate_email);
		}
	}
	// save the recipients
	current.recipients = emailTo.join(',');

})(current, previous);

View solution in original post

asifnoor · ‎03-16-2021

Hello Ashwini,

As Mahesh suggested already, you can select those recipients in the notification. If its not empty, then SN will send mail otherwise it will not.

If the notifcation is not on the same table where these fields present, then you have to write mail script and fetch the data.

Ashwini8 · ‎03-17-2021

Yes Asif,

I tried both the ways by adding event also, still not working, Its sending notification only to the secondary email id. Can you please suggest any other ways.

Thanks

asifnoor · ‎03-17-2021

Hello Aswini

Here are ways to debug

1. Can you to go system mailboxes->outbound->sent and check if the mail is there. if yes open that and check if you see TO and cc field filled with 1 or 2 email addresses?

Ashwini8 · ‎03-17-2021

In recipent list its showing only primary mail id, not the secondary mail id. I am not getting TO and CC option.

Ashwini8 · ‎03-17-2021

Hi Asif,

Actually the notification is written on incident table and email id fields are present in User table. So in this case can you please suggest how can i write mail script?