Frustrated VBA Newbie
 

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

Frustrated VBA Newbie
 

use datafilterautofiltercopy/paste to another sheetemail from there.
record a macro to see what is happening and then clean it up.
--
Don Guillett
SalesAid Software

"Marc" wrote in message
oups.com...
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