Hi Phil,

Thank you for your always support.

I checked the macro and it is ok, as I found the email address.

It just need to fix below point.

Please check attached, you will find in Column A, the Send Display name "Marsil Sarvis"  and In Column D, you will find the email address for sender as below

Marsil Sarvis <[email protected]>  and there is no data in E column.

So please can you handle this as below.

Column A, contain the email address for sender.

Column D, contain the email address for TO

Column E, contain the email address for CC.

Thanks is not enough, but really don't know what else say to you.

Thanks,

Marsil

No worries Marsil.

To get the email address for the sender change

Range("A1").Offset(i, 0).Value = Email.SenderName

to

Range("A1").Offset(i, 0).Value = Email.SenderEmailAddress

Col D should already contain the TO email address and Col E should be listing any CC email addresses.  When I test this at my end this is exactly what it is doing.

If it is not doing the same for you can you please provide a screenshot of the email showing the email(s) where it is not working.  Just the email addresses, you don't need to show the email content.

Regards

Phil

It works perfectly, thanks Phil!

You are amazing! Thank you so much!

Thanks;

Marsil

You're welcome 🙂