PDA

View Full Version : Copy rows from Outlook to Excel



shir0206
03-31-2019, 01:55 AM
Hello my friends,

I use Microsoft Outlook 2010/2013.
I created a rule that copies each sent/received appointment that contains the words “CCB Meeting” to the folder “CCB Meetings”.

Now, I would like to create a Macro in VBA in Excel, that runs throw “CCB Meetings” folder in the mail, and creates a list for each row of all the following information: From, Subject (Including the prefix ‘Accepted’/’Declined’ etc.), Received, To, CC, Start, End, Duration, Recurrence Range Start, Meeting Status, Conversation, Location.
(Exactly as it is in the print screen).

23966


Later on I could continue writing that code, in order to analyze these report of appointments.

I tried to do so, but I got stuck, because I don't familiar very well with Outlook objects...

Could anyone help me?