I have to send out a daily Staff Metrics email. The body of the email contains a list of items which I manually change based upon the morning report.

The Email goes to the same group of people each day and the Subject line is always "Staffing/Metrics - 2/28/23" but the date changes each day.

I am trying to create a macro that will sort my Outlook 2016 inbox by "Date Received" before it starts the search as I often have to resort by other fields throughout the day.
Then I need it to search from the newest email and find the previous or most recent email with the specific partial phrase "Staffing/Metrics - " in the Subject line.

Then I want to initiate a "Resend" of that email which should create a duplicate of the one previously sent.

I will take today's date and append it to the Specific String, "Staffing/Metrics - 3/5/23" and then I want to rewrite the Subject line with that update string, before sending the email.
At this point the macro can end and I will manually do the updates of all of the data in the body of the email and when done will manually initiate the send.

Any help with this issue would be greatly appreciated.