I am working on a VBA automation project for my company and hoping you can help me on the VBA looping part. I am still learning VBA loops and not very good at them yet.
I need a VBA loop that goes through an Excel table and copies-pastes a portion of the table/range from that table based on the column “oppty lead” e.g. for "Abhishek Singh" as oppty lead, only the table/range pertaining to his records gets inserted into the mailer sent to him for his comments.
In a similar manner, the marco then also loops through names of all other oppty leads in the xls and creates individual mails to them with their respective tables/ranges also copied-pasted into those mails.
Thanks in advance for your guidance on how this could be done.
I need a VBA loop that goes through an Excel table and copies-pastes a portion of the table/range from that table based on the column “oppty lead” e.g. for "Abhishek Singh" as oppty lead, only the table/range pertaining to his records gets inserted into the mailer sent to him for his comments.
In a similar manner, the marco then also loops through names of all other oppty leads in the xls and creates individual mails to them with their respective tables/ranges also copied-pasted into those mails.
Thanks in advance for your guidance on how this could be done.