I am trying to read outlook emails from senders that are requesting a pdf cert that would be obtained on a website.
- Read emails in a mailbox (Either one by one or All )
- Search for iso code the sender is requesting (Sometimes they mention it in the subject and sometimes in the body)
- Got to website get iso cert the customer is requesting
- Send link to website where cert is to customer in email , either reply or separate email
Example of an email 1
Subject: Request for Renewed ISO Cert
In review of our files it has come to our attention that your ISO 1234 and ISO 12345 certification has expired.
Another Example of potential email request
Subject: FW: ISO 1234567
Can you help me with this? xyz is requesting a new xyz ISO cert. The one on file expires 12/4.
Should i read these one by one , or read all emails export sender, subject, body to excel and go from there?