I need to have a VBA code to look at the name in column AR and then find the email in the global address book then send the email please. Thanks