Search Outlook subject lines for an email that matches selected cell value in Excel

Are we talking about Inbox or a folder?

By match do you mean subject match, in which case, do you mean partial or whole match? Or do you mean thread match? (Outlook has data for which mails belong to the same thread).

Exactly what do you mean by Most Recent? The last person to respond? or messages not responded to yet?

I think this will work for you.


In cell B2, enter in the name of your mailbox: yourname@yourdomain.

In cell B4, enter in the subject you want to search for. The program will strip off the Re: and Fwd: that appear on the subject lines in the box

In Cell B6, enter in any message that you would like to start the reply message with.

Click the button.

There is a piece of the code you may want to change.

Please Login or Register  to view this content.

As the code is set up now, the message will be set up and brought up on the screen for further editing. It will not be sent until you press send in Outlook.

If you comment this line out and comment in the .send line, then the message will be sent without intervention.

Thank you very much for your help. This looks promising. The only issue I am running into is that when I change .body to HTMLBody and hit reply all, it makes it look like my response is part of their original email. I can provide a screen shot in the morning when I get to work.

EDIT: Actually, it puts the new text in the original body even if I don't change it to HTML.

This means that you have .Display enabled. This allows you to further edit the message before sending it manually.

If you want the message to be sent automatically without intervention, then comment out .Display and remove the comment quote from .Send.

There is no way to display it with the new message above the old? Any time I have used .Display, it would display the message as if I already clicked reply. This current method is forcing me to click reply manually after the message gets displayed. Also, even if I choose .Send, it is still combining my new response with the original message, rather than placing the detail of the original message below my new response.