J
juanpablo
Hi,
I have the following problem:
A table in file1.xls as follows:
Person QTY email
A 23 [email protected]
B 15 [email protected]
C 18 [email protected]
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
person"x"@company.com with a template(fixed) subject and body message and
also attach the corresponding file_person"x" to the email.
Challenging?
I have the following problem:
A table in file1.xls as follows:
Person QTY email
A 23 [email protected]
B 15 [email protected]
C 18 [email protected]
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
person"x"@company.com with a template(fixed) subject and body message and
also attach the corresponding file_person"x" to the email.
Challenging?