Below is a snippet of the code I use to send emails from excel. I would like to expand this to change the sent from based on a list of vendors. So What I think is as the email is generating it would compare the field "VND" which is the vendors name against an excel spreadsheet and change the...