Are you using IMail_Address in your code for the vlookup and Mail_Address when assinging the email to the .to property? That will be causing a problem.
Also, you don't increment the count in your code (you need something like count = count+1 at the end of the loop) so it will presumably get stuck in an endless loop.
As I mentioned in post 2 you need to change .body to be what you actually want to send. To send columns A to F it would be something like:
To send all rows with a specific value in a single e-mail you will need to change the structure of your loop. As you move down column G the process would be:
-Find if value has already been sent (check values in rows above)
-If it is first occurance, loop through to bottom row to find all the other rows with same column G value
Bookmarks