Hello Excel VBA Gods or Goddes!

I need help with the following issue or if you can point me to a good
resource.

Problem: take a whole employee login list(1100+) and sort by
department email the part of the
        list they goes to that department with outlook express.

Applications: Excel 2000, (XP)Outlook Express

Details:

Sheet1- Logins (list length is dyamic in nature with employee's
leaving or getting hired)

Starts at
A6: Lastname B6: Firstname C6: Username D6: Password  E6: Employee
Number
F6: Dept.Number

Sheet2- Dept Heads (list length is dyamic in nature with ablity for
department growth)

Starts at A6: Dept. Number B6: Firstname C6: Lastname D6: Email
Address

Output in email:

to: <Email of department head>
Subject: Employee list for Dept. <insert dept. #>

Message Body:

    Hello <Department Head Firstname>,

        Below you will find a login list for your employee's in your
department.

        <insert list in table or coloum form.
            alphabetized Lastname,First Username password Employee #>

    Note: Please do not post or allow other employees to see this list.

    Thankyou,

    Admin Team

==============================

So Any ideas? Your help is greatly appreciated!

~Marc