VBA-select cells meeting specific criteria & email

[N3rdgrl]

Hello! Any help with this is appreciated including but not limited to actual code. I'm trying to help someone streamline a process but this is a little above my skill level.

Here is what I want to accomplish:
After pasting data from a .txt file into column A on worksheet "Data"

send an email to district managers containing only the data from column A in worksheet Data that are for location codes in their region. I need the data in the body of the message not as an attachment.

Possibly important factors:
There are currently 224 locations divided into 6 regions
The location code (a 5 digit #) will be buried in the line pasted in column A (meaning not always the first or last thing on the line)
Row counts will change
Some data will not be sent (I can have the user delete what doesn't need to be emailed but if there's a way to code it why not!)
If there is nothing to report no email should be sent


Again, thank you for any advice! Rest assured that I will not claim credit for your work! Anytime I have borrowed code I note where it came from in a comment so if you'd like me to note something other than your MrExcel.com user name please let me know!

 

[VoG]

This is a big question so you are not going to get the answer in a single post.

Take a look at Autofilter to extract the data (see Excel Help).

For e-mail code http://www.rondebruin.nl/sendmail.htm