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
Bower macro ring light dx6490 Error message when opening link in email Excel macro that creates border around populated cells Hacking hotmail email passwords How do you recover a gamertag when you can't remember the email address you used? How to retrieve ur friendster email How to send email from website If cell is empty delete row macro Is there any other way i can send an email not through hotmail? Linking command button to macro Lupa password email live Macro define sheet and cell Macro sheet.cell Make outlook macro run automatically when opening new Msn email saved Pdf files can't be sent through email What email do i put in when im setting up my online for the ps3 Yahoo mail cannot open email