This is an update in functionality to question: Part 7 to: Import more data into spreadsheet -
In addition to what is done with the macro created in Part 7 I need the function to do the following, if possible:
1. Currently it creates an email (WHEN a value is inserted in Col N AND there is a value in Col K) but it would be best if it could find the original email, open it and forward it with its contents, (including its attachments) to the same email address with same subject and body the macro created before.
2. When sent, insert today's date into Col P of Applicant Status
Is it possible to do #1 without knowing the subfolder the original email is stored?
If not, the original email would not be in the Inbox but in a subfolder named: USD Mastercard. The hierarchy goes like this: Inbox > Applicants> USD Mastercard