Excel VBA - Send outlook email

In Cell A I have names, e.g. John Smith
In Cell B I have a criteria - Due/ Not Due.
I need to somehow modify the below code to do the following: 
Generate emails from cell A, in the format john.smith@company.com and Then send out a reminder email, but only to unique emails in one email

  Devbrat Tripathi

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any