I want to run a macro with will parse & segregate the Outlook Mail Fields to Excel
I get the Fields of Outlook mail through the following code
It generates an Excel Sheet in this format
Which I process and move the required rows to Two Different Sheets
1) Approved 2) InProcess
1) Approved Sheet (Done Manually)
2) InProcess Sheet (Done Manually)
Manual Steps I do to segregate the data
I'm doing this manually every day, which is taking much time and efforts, I get almost 100 to 150 requests and followup mails to be checked in.
I have a Macro to extract fields of entire Outlook Inbox, but No clue to segregate the data!
I need your help in automating this process. Please let me you know if you need any inputs. I'm attaching a sample file for your reference.
Thanks a million in advance
Sample_Outlook_File_Processed_Manually.xls
Bookmarks