Respond email using Outlook based in data in Range A9 (from attached file)

Hi people,

I hope someone can help me on this request.
On a daily basis I receive many requests through Outlook asking for invoices. I need to ask someone else to create them respectively. The titles of those emails that I receive from customers have as subject these words "Natures sent a new Purchase Order ADG0246519". Words that never change are "sent a new Purchase Order".
The Purchase order always change and may have only numbers or letter and numbers.

In the attached file I have a basic code that helps me to ask my third party company to create the invoices however this macro creates a new email without considering the original request from my customer. What I want to do is solicit the creation of the invoice but I want the macro to look up in my Outlook and find the email that has the PO# in the subject. The PO# would be always in "A9" from sheet2 (in the attached workbook).

If PO# is not find, exit the sub.

.
If the email addresses in your macro code are valid addresses .. you might want to edit them to avoid spam.

Hi Logit, these are not valid. Any suggestion on the code?

.
Sorry, I am not that familiar interacting with Outlook. I did a quick internet search on your request and located a ton of resources that explain
how to search the SUBJECT field of your Outlook mail for a specific term. If no one responds to your request here, you may want to attempt
an Internet search.

Hi dflak,

- Will the PO number always be the next string after the words, "sent a new Purchase Order"? YES
- Also I see you have multiple lines for the same PO.... THIS IS CORRECT AND ALL OF THOSE LINES WILL BE ALWAYS THE SAME PO
- Is there an attachment in the email or is this information embedded in the body somehow? ... THIS INFORMATION IS EMBEDDED IN THE BODY

I have attached an example of emails that I receive and the one I send.

Hi,
I know this sounds confusing and appreciate your help.
The email on the bottom of the word document, is that what you get in or is it what you want to send out? ... actually this is what I currently send out. However my wish is to use the original email (on the top of the word document) to reply and not create a new email.

Hope this helps.

Yes, that is what I want to achieve, get the email from Outlook that has the PO from the subject line.

Hi, I attached a file that you can run, this is what you can use to send (emails are not valid).

The goal is to look up the PO that is in range A9 within my outlook received emails, take the email that has in the subject the PO and send the information.

Thank you, it did work.