I need a macro to update excel file based on Outlook mail.
I have a file named "project number addition" which has sheet named"project no" which has project numbers in column C and status in column G.
I have a macro which send mail to a person requesting to add the project number with subject "Project number creation: xxxxxxxx"
The person will send mail back informing us whether added or not added.
I have created a rule in outlook to move mails to a folder named "project number" with subject"Re: project number creation:xxxxxx"
I need the macro to go through the mails in this folder and match the project number from column C and subject, and update whether is has been added or not added from body of mail into columnG.
Reply mails contains only either "Added" or "Not added"
Thanks in advance.
I have a file named "project number addition" which has sheet named"project no" which has project numbers in column C and status in column G.
I have a macro which send mail to a person requesting to add the project number with subject "Project number creation: xxxxxxxx"
The person will send mail back informing us whether added or not added.
I have created a rule in outlook to move mails to a folder named "project number" with subject"Re: project number creation:xxxxxx"
I need the macro to go through the mails in this folder and match the project number from column C and subject, and update whether is has been added or not added from body of mail into columnG.
Reply mails contains only either "Added" or "Not added"
Thanks in advance.