VBS Code to Pull Email SMTP Address From Outlook And Send Email

[cdurfey]

I need to get vba to look at the name in column G and find the email in outlook global address list. Thanks