Macro to import Outlook Fields to Excel

Hi

I am trying to create a macro that collects the fields from each Outlook message in the selected Outlook folder and writes the values of the fields to an Excel worksheet.

The goal is from excel to be able to retrieved statical information in outlook by creating a link or a VBA.

EG. from - to - receive date - categories (if possible)


Thank you for sharing your knowledge.



Nick

trying to pull outlook data from excel is not likely to be easy since you're running into the security wall setup to help prevent people from writing macro viruses that steal email addresses into an excel file and then post the file somewhere nefarious.

However, pushing the data from Outlook to Excel tends to be a little easier under the assumtion that you're the only one who can get code to execute under your outlook session.

Please Login or Register  to view this content.