hi all,

i wanted to be able to search for a keyword within outlook's public folder. normally to do this is to just use that search function in outlook, but because i have a lot of keyword to search i'm thinking if i can automate this search process by reading keyword from an excel file using vba to search for the mail in outlook. pls see below for the steps...

1. run macro, pop up box ask for excel file input (file is a list of keyword)
2. outlook read in one entry of the list, searches in mail box and public folder for the keyword
3. copy the found file to another folder (can be outlook public folder or local drive)
4. read in next keyword and search, repeat the process.

Can someone pls tell me how can that be done?

Search where? In the subject, body, somewhere else?

What sort of items are in the public folder?

What version of Excel/Outlook/Office are you using?

Do you have any VBA programming experience? It would help if you already had some code written, instead of just asking for code to be written for you.


HTH,
JP