Hello,
i got a workbook with a report sheet. based on the type of report it should be emailed to selected people.
on a seperate sheet, the report type, email id of people to be put in the TO field and CC field is listes. the macro has to loop through the type of report first, then loop through the field, add email id to the TO field and add id to the CC field

the column heading in the email sheet are
categories name Email_id Addresse field
Pending Card M m@gmail.com Dear M To
Pending Card D d@gmail.com Dear D CC
Pending Card E e@gmail.com Dear E CC
Claim A a@gmail.com Dear A To
Pending Claim B b@gmail.com Dear B To

for all the pending card category, the report worksheet from the same workbook has to be emailed to the people in the to field and people in the cc field with dear m in the subject with some static text.

Configuration: Windows XP
Firefox 3.0.8