MiniMacros
New Member
- Joined
- Jul 2, 2010
- Messages
- 7
Hi all - apologies as this is something that should be pretty simple, but I have unfortunately not been able to find the solution with a search so I must be using the wrong verbiage.
I have already completed a macro that sends an email based on 3 inputs ("To" email field, subject line, and body of email). I separately have a table I am creating that will have contain these 3 variables (and others) in each column, with multiple different entries in each row. The goal is being able to send multiple unique emails at once by going through each row using the previously mentioned Macro. For example Column A says "Organization Title", Column B is the "To" field, Column C is the "Subject Line" and Column D is the "Body". How do I create a macro that will loop through each row in the table and let me grab the text strings out of all the Columns to pass onto my other macro? I already feel comfortable passing the 3 variables to a different Sub, just need the code to iterate through each row and get the 3 variables out of the data table into string variables in VBA.
I have already completed a macro that sends an email based on 3 inputs ("To" email field, subject line, and body of email). I separately have a table I am creating that will have contain these 3 variables (and others) in each column, with multiple different entries in each row. The goal is being able to send multiple unique emails at once by going through each row using the previously mentioned Macro. For example Column A says "Organization Title", Column B is the "To" field, Column C is the "Subject Line" and Column D is the "Body". How do I create a macro that will loop through each row in the table and let me grab the text strings out of all the Columns to pass onto my other macro? I already feel comfortable passing the 3 variables to a different Sub, just need the code to iterate through each row and get the 3 variables out of the data table into string variables in VBA.