Greetings Folks,
I have a problem. I need to take a text delimited file from Access
and import it into Excel. Then parse out the information via the Owner
to separate worksheets and make the name of the sheet the Owners name
then email the sheet from Excel. Can anybody help?

Example of my Text File:

Company Owner
Phone Number
Quest Jim Smith
555-5555
Quest Jim Smith
555-5555
Pacific Jane Doe
555-5555
Pacific Jane Doe
555-5555
Eastern Joe Blow
555-5555
Eastern Joe Blow
555-5555

What I need is to sort by owner and make separate worksheets with just
that owners information. In this case I would need three worksheets one
for Jim, one for Jane, and one for Joe. Then at the bottom of the sheet
where it says "Sheet1" I want to have the Owner's name like Sheet 1 -
Jim Smith and Sheet 2 - Jane Doe and Sheet 3 - Joe Blow. Then email the
each worksheet to the owner. Could anybody help me with this?