Present user with dialog box, user will select folder of interest in Outlook 2010 There are several different fields for a ..I think mailitem? Email address, First Name, Middle Name, Last Name Find a way to identify if a field constains an email address and only an email address. Use Regex? #1 For each mailitem If the email address field does contain an email address, then overwrite Firstname, Middle Name and Last name and put the email address in there. When done, The email address field, the first name, middle name and last name will all contain the same email address. If the email address filed does not contain an email address, check if the first name, middle name or last name contain an email address. If any of those fields do contain an email addresss, copy that email address to the email field and then have the first name, middle name and last name also show that email address If nont of the fields contain an email address, export all the fields to an excel worksheet for that mailitem. When the program is finished, the user can view on the worksheet all the fields that did not show an email address. #2 Present user with dialog box again to choose a folder in Outlook 2010. Then an inputbox to enter a Search Term. Present the user with a dialog tickbox where they can check the fields they want searched for an occurance of the Search Term. If the SearchTerm is found in a mailitem in any of the user selected fields, export that data to an excel worksheet. The header values would be the name of any applicable field (all possible, not just the user selected for the search). For example this should include email address, first name, last name, body of the email, subject line, etc..
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!