Outlook VBA Wildcard

I currently have (Opened At 2:46) in my subject from a macro I created, with 2:46 being updated every time I use my macro with the current time. What I would like to happen, is when I receive an email back from the recipients, when I click reply all it searches for "(Opened At" in the subject and replaces with "(Closed At 2:50" with 2:50 being the current time. So I need to figure out how to use * as a wild card or just if it finds "(Opened At" then just erase the subject and put (Closed At Current Time)

Please Login or Register  to view this content.

Neither worked, but could it be because it's searching every reply all? Opened and Closed isn't in every email.

Please Login or Register  to view this content.

Originally Posted by shg

I can't see that your question has anything to do with Outlook:

I don't understand how you don't see the question for outlook? The VBA code runs on Outlook starting, then when I click reply all I need it to search the subject and if it finds a match, replace it with (Closed At Current Time Frame). I am assuming your code is an example, so I tried to incorporate into my code, but I get error Object missing. Any ideas?

Please Login or Register  to view this content.

Run-time error 424
Set oResponse = oItem.ReplyAll

Not sure why it is erroring out there now?

Please Login or Register  to view this content.

I ended up getting it working when I just decided to do a manual search and replace with it, but the problem is, it saves to the subject, but doesn't display it in the Reply All Subject line. I have to close out of the Reply All popup and reopen it?

Please Login or Register  to view this content.