Hi,

i have 12 sheets in excel and i want to send email to 12 people with the their attachment and cc to manager.
so when i send the email the manager will get 12 emails instead of that for manager should get 12 sheets with one workbook but should be able to know each sheet send to 12 members and members also should aware the manager received the their sheets.

please help