Excel vba sending email validation list

[E5254730]

Hello Experts,

I have one File with me. I want to create a button in sheet 1. The Column A shows list of locations. So once I select the the location from the drop down list (say I select "Searcy" as my location) to whom I want to send emails. So all the 3 rows which has the records/data for Searcy location, Excel should automatically attached this file to Outlook (there should be only 3 records to this attached file in Outlook).

This should also contain the Subject line and the body. In my email Subject Line and body will be same for all the locations I'm sending e-mails to, only the location will be changed.

Let me know if you still require any additional clarifications.

Many Thanks,
Prakash