![]() ![]() Set FSO = CreateObject("Scripting.FileSystemObject") Hence, I conducted a short research resulting in the following VBA function: VBA to extract Outlook recipient information The other easier way – the corporate Outlook correspondence group containing all active employees and to somehow dump this data to an Excel/CSV file for analysis. And even then this would require verifying the data and some cleansing. ![]() A process that would last at least a week before I could get my hands on the actual data. One way to approach this assignment was to contact HR, which would then need to contact regional HR … and so on. I once received an assignment which required analyzing the data of all employees in our company. Lot of data is stored and is accessible via Outlook – although mostly not appreciated. Being a corporate Consultant I always thought of the vast amount of data stored in various corporate databases that could be put to good use. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |