Excel macro to download email attachments based email subject lines listed in excel

[abhay_547]

You don't need const for path. Just use what you commented to set the value for path.

To use another folder, you will need the path. Look at how I got that and used it in this thread: http://www.vbaexpress.com/forum/show...ch-appointment

For the marking read, maybe:

'other stuff
If olitem.attachments.Count <> 0 Then
  olitem.read = True
'other stuff

I don't know what you mean by subject line unique parts.

Subject line unique part means for e.g. the subject line of an email is "Daily Fund Report 04162019 REF548725", now in this the "Daily Fund Report" is the unique part since it doesn't change daily but the date and the REF number changes daily so we have to identify the mails based on the unique part so if the email subject line consists of Daily Fund Report then macro should download it's attachment and mark it as Read.