Hi All,
I am new to this forum and a beginner with Excel Programming/VBA/Macros. What I am trying to do is find a way to automate a manual process that we currently do. Any suggestions/coding is greatly appreciated (please describe in laymen's terms..as I stated a beginner).
Current Process:
We have Word document called Academic Progress. We do an email merge process that populates the instructor's name, their ID, student's name and ID, course, course title and course reference number (CRN) and emails the instructor of that course. The body of the email has information that we would like to know about the student; 'Current Grade and/or Progress in Course" and "Level of Performance". Using Outlook the instructor selects 'Reply', fills in the body of the email and then sends. We have a specific folder that these emails are saved in "Dept", sub-folder "Academic Progress". The emails are printed off and the Administrative Assistance then manually matches the instructor/student/course number and then enters the information from the body of the email in to the "data source" spreadsheet we used for email merge.
What I would like:
1. Continue to use the email merge process.
2. When the academic progress doc is emailed back, stored in folder Dept--> sub-folder Academic Progress.
3. Have a macro in the "data source" spreadsheet that looks at the outlook folder, selects the first record on spreadsheet. If column A, responded IS NULL then searches for a match on Inst ID, Student ID and CRN. Finds match then in column A, populates responded with 'Y' and populates columns R-AC , appropriate information from the body of the email. If column A, responded = Y, skip that record and go to next until end of file.
I have attached a sample spreadsheet (1 row could have up to 100) and word doc used in email merge.
Again any help is greatly appreciated..
Bookmarks