PDA

View Full Version : Validation Tool- Lookup for Mis-Match and send email out



vradhak7
12-21-2016, 04:07 PM
Hello Experts,
I have attached the file for reference. I have a file in which i calculate is there is a mis-match( in column E) of "Summary" tab. Whenever there is a is-match, I want VBA to lookup the region in column A and send out an email looking up to the corresponding email address in the tab "Contact List" which has email address segregated by region. The email should say "Hello, There is a volume mis-match for your office New York( "or whatever office name in Column B of summary tab") and preferably attach the row from Column A to E( only the row which is a mis-match).

VBA has to loop through all rows and so the same process.
17889
How do I do it using VBA ? Your expertise would be greatly appreciated.

Regards
vradhak7