eddyrcabrera79
Member
Hello all,
Could you please help me with the creation of the macro.
I have an excel doc that in each row it will contain information including email address about several clients. when I run the macro this is what I would required (This is an example)
1 - it will send a separate email to each person in the column B
2 - in the subject line per email, it would say: REMINDER FOR + the information in column G
3 - it would have a greeting saying: Dear + the information in column A
4 - in the body of the email, it would say something like this but values from the columns will be used too. For example
your color (Column D) will be changed on (Column F). We will go to the address (Column C) using the code (Column G)
5 - As a signature it will be something like: Sincerely, Eddy
6 - and each email will contain the same attachment that it will be located on my computer in a folder called Update, ex: (D:\Update)
Thanks in advance
I attached a sample in order to have a better idea
Could you please help me with the creation of the macro.
I have an excel doc that in each row it will contain information including email address about several clients. when I run the macro this is what I would required (This is an example)
1 - it will send a separate email to each person in the column B
2 - in the subject line per email, it would say: REMINDER FOR + the information in column G
3 - it would have a greeting saying: Dear + the information in column A
4 - in the body of the email, it would say something like this but values from the columns will be used too. For example
your color (Column D) will be changed on (Column F). We will go to the address (Column C) using the code (Column G)
5 - As a signature it will be something like: Sincerely, Eddy
6 - and each email will contain the same attachment that it will be located on my computer in a folder called Update, ex: (D:\Update)
Thanks in advance
I attached a sample in order to have a better idea