M
Marc
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
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