VBA code that searches all emails sent on Outlook based on specified information given

VBA code that searches all emails sent on Outlook based on specified information given

Hi everyone,

I hope you are doing great and keeping safe. I need your help to create the following VBA script that searches for all emails that contain the following:

• Sent from a specific date onwards
• Subject: * OQ#123456 * <-- always six (6) digits, can have more information before and after and possible spaces in between
• Has an attachment
• The BCC line has emails on it.

With the emails found, we need to create an Excel file with the following:

Column A - OQ#'s	Column B - Emails
OQ#12345	email1, email2, email3, email4
OQ#12345	email1, email2, email3, email4

The emails in the table are only those used in the BCC line.

Can you please help????

that's a lot of work, and there probably isn't an exact example on the web anywhere. however, you need to start here:

- check the sentOn property: https://docs.microsoft.com/en-us/off...ailitem.senton

- check the subject using the instr() function and other string functions. see these:

https://docs.microsoft.com/en-us/off...ilitem.subject

https://docs.microsoft.com/en-us/dot...ring-functions

- check the attachments property for a count > 0: https://docs.microsoft.com/en-us/off...em.attachments

- check the BCC property for a value of one greater than a zero-length string: https://docs.microsoft.com/en-us/off...k.mailitem.bcc

to see how to loop a folder in outlook from excel, more or less copy what this person did in post #1:

https://www.excelforum.com/excel-pro...ng-format.html

more info here:
https://docs.microsoft.com/en-us/off...tlook.mailitem

Thank you Adam - will check it out.

post back here if you need help.

Thanks for your advice. I was looking for this.