Experts,
Can please advise how to check the file name with the address book and return the email address in the To field.
Scenario:
In a folder I have multiple excel files saved with different person names. I am having macro to attach the files in a separate email message.
Now, I need a macro...