vba work outlook with excel sheet
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?