Bursting process with excel template
I have a situation here, have to send mails(with report as attachment) to Business based on cost centers(CC) assigned to them. I have designed data template in such a way
Group1 - CC Owner
Group2 - CC
Group3 - CC data
end Group3
end Group2
end Group1
Here I have to send a mail to each CC owner with all cost center details assigned to him/her with each cost center details in different excel tabs. For example, if owner A has CC1, CC2, CC3 assigned to him then it has to send one mail with CC1, CC2, CC3 in different tabs. Like this we have few cost center owners.