Smartnote Bursting on two email fields

One way to do this is to change the sql of your smartnote to include the email of your supervisor as a field i your smart note. You cna then burst the smart note twice. One for the HR contact and the other to the supervisor.

So essentially I'll be creating two Smartnotes, one sending emails to HR Contacts, and the other to Supervisors? My SQL is already pulling two Email fields I just don't see how I can burst it to two fields in the Bursting tab. Has anyone done this before?

Thanks,

The method previously described is how I have done it in the past, you are literally simply creating a copy of the current notification and updating the delivery portion to link to the supervisor field instead of the employee.

However if you really want just one notification, then there is an alternative. You would need to modify your query and notification. Update the query so it dumps two rows for every row you currently dump, and have a 'burst' email field. On one row use the employee's address and on the other use the supervisor's.

I'm not a DBA but my off the hip thought would be to use a UNION between two select statements, one which is your current SQL with the employee's email in the field and then UNIONed to the same select statement modified to fill in the supervisor's email in the 'burst' field.

I've never used this method since most of my infosets are multipurpose and having two rows for each actual data row would cause problems.

That answers my question. Thank you!!