Program
 

Hi,

I have the following problem:

A table in file1.xls as follows:

Person QTY email
A 23
B 15
C 18

And also 3 excel files with detailed information for each person, as follows:

file_personA.xls
file_personB.xls
file_personC.xls

So I need to have a macro that copies the information from table from
file1.xls. specifically column email and send an email to
with a template(fixed) subject and body message and
also attach the corresponding file_person"x" to the email.

Challenging?