I have a problem that is doing my head in and could use your help if you can spare 5 mins thanks.
We have a shared mailbox where emails arrive that have attachments that are PDF statements.
The emails also have inline files which are footers, (senders business jpg etc) but we only interested in the actual PDF file attachments
We have a spreadsheet with 3 columns in SharePoint, (Incoming_email, Email_SUbject, New_File_Name) this file has about 1800 rows. This may have multiple entries of the same email address Incoming_email but the EMail_Subject will be different as often vendors all use the same company like xero to send statements.
Process:
When an email arrives in the shared mailbox.
- we need to cross check the spreadsheet and see if the incoming email address matches anything in the Incoming _email field
- we need to cross check the spreadsheet and see if the incoming subject matches anything in the Email_Subject field and if it does we need to save the NON INLINE attachment with the NEW_FIle_Name into a SharePoint folder location
- IF the incoming email matches but the subject does not match then we need to still save the NON INLINE attachment with the NEW_FILE_Name in a Sharepoint folder
- IF the email address does not match anything in the Incoming_email field then it needs to forward to a specific email address for review
I have tried a lot of different designs and some get close but none work so i would be keen on getting a fresh set of eyes and input if i could
