vpr
01-23-2006, 02:04 AM
Sorry about the length, but I can't explain it in a short description... Please don't be turned off by the length of this msg!
Hello,
I work in a department with 19 other people. Regular agents fill out a form on their computer that gets sent out to us requesting information to be mailed to a customer, if the request is invalid we then send an email to the agents supervisor w/ a reason as to why.
I currently have been working on an excel document to try and automate the task of sending the emails out, I have a DATA tab that has the supervisors's name, email address, and nick name (A2:C64) In Columns F2:F10 are some pre-written statements as to why the request was invald and in G2:G10 there are some extended reasons.
Everyone in my department has a seperate sheet (19 of them, labeled as their name) and every user will fille out in this order: Account Number, Date of Request, Coach Name, Reason for Invalid (Points to Column F of the data tab), Description to be used if other is selected in the previous cell, and Email Sent (Yes/No). This is B5:HWhatever (will go on forever basically).
The macro should take all this information and generate an email that would then be sent to the correct superviosr.
Before the macro is run, I'd like a form to come up and ask if they'd like to run it on Everybody's Sheet, or just their own. I'd also like to have a progress bar while this is running as it could take some time depending on how many emails needed to be generated. The Information is then put into a "Team Summary" sheet which lists all the summary's sorted by date and then this information is used on a chart for the supervisor of MY department.
This sounds like a simple thing to be done, but i've been having problems getting it done... I'm open to suggestions to changing the workbook completly, but it does need to be friendly to multi-users at the same time...
All the work computers we're on have Office XP (Includding Outlook), with IE only.
Thanks a lot - I really appriciate it!
Hello,
I work in a department with 19 other people. Regular agents fill out a form on their computer that gets sent out to us requesting information to be mailed to a customer, if the request is invalid we then send an email to the agents supervisor w/ a reason as to why.
I currently have been working on an excel document to try and automate the task of sending the emails out, I have a DATA tab that has the supervisors's name, email address, and nick name (A2:C64) In Columns F2:F10 are some pre-written statements as to why the request was invald and in G2:G10 there are some extended reasons.
Everyone in my department has a seperate sheet (19 of them, labeled as their name) and every user will fille out in this order: Account Number, Date of Request, Coach Name, Reason for Invalid (Points to Column F of the data tab), Description to be used if other is selected in the previous cell, and Email Sent (Yes/No). This is B5:HWhatever (will go on forever basically).
The macro should take all this information and generate an email that would then be sent to the correct superviosr.
Before the macro is run, I'd like a form to come up and ask if they'd like to run it on Everybody's Sheet, or just their own. I'd also like to have a progress bar while this is running as it could take some time depending on how many emails needed to be generated. The Information is then put into a "Team Summary" sheet which lists all the summary's sorted by date and then this information is used on a chart for the supervisor of MY department.
This sounds like a simple thing to be done, but i've been having problems getting it done... I'm open to suggestions to changing the workbook completly, but it does need to be friendly to multi-users at the same time...
All the work computers we're on have Office XP (Includding Outlook), with IE only.
Thanks a lot - I really appriciate it!