MS Outlook - find subject line by VBA (in excel)

[Akshay Divecha]

Hi Experts,

I need help regarding Outlook VBA.

I have subject lines mentioned in an excel file, for example Range A3, A4,A5,A6

I need to check in Outlook 2016, Inbox if mail with subject line mentioned in
Column A is received or not.

If received, then details such as senders address, subject line, received date to be copied in column B, C & D

Also the hyperlink of the email to be created on column E

Can anyone please share the codes

Thanks in advance...

 

[Belleke]

Hi,
Hope this helps.
No need to open outlook but when outlook is open the code is faster.
See attached
Mails received less or equal to 6 days will appear in the results, change to your needs.

 

[Akshay Divecha]

Hi Belleke,

Thanks for your work, got the error msg as attached.

any possibility to find the emails within a range of 1 month.

Also if i can add subject directly in column B instead of adding it from "Add Subject"

Also if subjects are deleted from column B, it does not gets deleted from "Find" button.

Please help !

Once again thanks.

 

[Belleke]

See attached (2)
The first example
Add or delete subjects in column B, push the renew button to reload the combobox
The second example, click a subject in Column B and push the search button
IMPORTANT!! I forgot to mention yesterday.
In the VBA editor you have to check Microsoft Outlook 16.0 Object Library
in Extra -> References

 

[Akshay Divecha]

Thanks once again Belleke,

But there are some errors which need your help to fix.

Seems all mails are fetched instead of desired mail.

Hyper link is also not working.

 

[Akshay Divecha]

Dear Exports / Belleke, please help on this one...

 

[Akshay Divecha]

Dear Experts,

Need your help..