reply on last sent mail (from excel to outlook)

Hi everyone !

I was looking for a way to create a macro that would allow me to:

- 1 - read a list of mail address (written in the same column in Excel)
- 2 - then for each mail address, search in Outlook (let's make it search in "All Outlook Items" to make it more general) and then open the last item related to this mail address
- 3 - once this item is opened (let's make it simple and assume it is a mail), reply while adding a short text and an attachment
- 4 - eventually send the reply

I know how to write steps 1, 3 and 4 but I'm currently stuck on the step 2: I know how to use vba to lookup in Outlook for an item from Excel but can not find the way to ask to open the last sent/received item: it will open a random item.

In case there is only one item it's perfect, but it's more complicated when you have more items.

Would anyone have a clue on this ?! I hope you will find this as challenging as I am !

Have a very nice afternoon,

Best

Alex