surah79
asked on
Outlook Macro
Hi
I am managing 9 outlook inboxes with various subfolders. Is it possible to create a report in excel via macro with a break down like how many email received every half an hour in the whole day across each inbox.
Thanks
Output in Excel
\\\customerservice\ 8:00-8:30 am - 10
\\\customerservice\ 8:30 - 9:00 - 12
\\\customerservice\ 9:00 - 9:30 - 14
I am managing 9 outlook inboxes with various subfolders. Is it possible to create a report in excel via macro with a break down like how many email received every half an hour in the whole day across each inbox.
Thanks
Output in Excel
\\\customerservice\ 8:00-8:30 am - 10
\\\customerservice\ 8:30 - 9:00 - 12
\\\customerservice\ 9:00 - 9:30 - 14
ASKER
14.0.6129.5000(32 bit) from outlook but excel is also fine.
Thanks
Thanks
I haven't a clue what the number means … can you talk in terms of the 'common' designation for example outlook 2010 / 2011 / 2013?
note if I use the example of mine then its 14 something in the full version but outlook 2011 in the common 'version'. I recognise when I say version you have responded literally but what i need is the boxed version rather than the low level detail.
Chris
note if I use the example of mine then its 14 something in the full version but outlook 2011 in the common 'version'. I recognise when I say version you have responded literally but what i need is the boxed version rather than the low level detail.
Chris
ASKER
Outlook 2010
Version is good to allow most things, when you say inbox folders are these sub folders of the one inbox or multiple psts each of which has an inbox?
Chris
Chris
ASKER
Yes multiple sub folder in one inbox,so I will keep changing the inbox name to generate the report for the other inbox with multiple folder and then combine everything
Sorry but trying to get my head around this:
pst1
inbox
folder 1
folder 2
…
folder n
pst2
inbox
folder a
folder b
…
folder z
…
pstn
inbox
folder 1a
folder 2b
…
folder nz
or something else
Chris
pst1
inbox
folder 1
folder 2
…
folder n
pst2
inbox
folder a
folder b
…
folder z
…
pstn
inbox
folder 1a
folder 2b
…
folder nz
or something else
Chris
ASKER
Yep
I believe something can be done but processing so many sub folders will take some time so how far down do we need to go all sub folders or just the first level and do you want the mails identifying against the past or by folder?
ASKER
Hi just want to go all sub folder down ;mails identifying against should be the time slot
8:30 - 9:30 20
9:30 - 10:00 30
Then I can run 9 times at diff inboxes separately and make the combine report
Inbox structure is as below
Inboxa
Sybfolder1
SSub folder 2
Sub folder 3
Sub folder 4
8:30 - 9:30 20
9:30 - 10:00 30
Then I can run 9 times at diff inboxes separately and make the combine report
Inbox structure is as below
Inboxa
Sybfolder1
SSub folder 2
Sub folder 3
Sub folder 4
I was assuming you wanted one script that ran through all the psts?
My latest question however was do you want:
\\\customerservice\ 8:00-8:30 am - 10
\\\customerservice\ 8:30 - 9:00 - 12
or
\\\customerservice\ 8:00-8:30 am - 2
\\\customerservice\subfold er1 8:00-8:30 am - 5
\\\customerservice\Subsubf older1 8:00-8:30 am - 3
etc
Chris
My latest question however was do you want:
\\\customerservice\ 8:00-8:30 am - 10
\\\customerservice\ 8:30 - 9:00 - 12
or
\\\customerservice\ 8:00-8:30 am - 2
\\\customerservice\subfold
\\\customerservice\Subsubf
etc
Chris
ASKER
Second one with the sub folder
I have some test code that evidences the basics to meet this however at the moment it processes folders then times and this is another area where the requirement needs refining:
\\\customerservice\ 8:00-8:30 am - 2
\\\customerservice\ 8:30-9:00 am - 1
\\\customerservice\ 9:00-9:30 am - 5
\\\customerservice\subfold er1 8:00-8:30 am - 3
\\\customerservice\subfold er1 8:30-9:00 am - 5
\\\customerservice\subfold er1 9:00-9:30 am - 2
or
\\\customerservice\ 8:00-8:30 am - 2
\\\customerservice\subfold er1 8:00-8:30 am - 3
\\\customerservice\ 8:30-9:00 am - 1
\\\customerservice\subfold er1 8:30-9:00 am - 5
\\\customerservice\ 9:00-9:30 am - 5
\\\customerservice\subfold er1 9:00-9:30 am - 2
Chris
\\\customerservice\ 8:00-8:30 am - 2
\\\customerservice\ 8:30-9:00 am - 1
\\\customerservice\ 9:00-9:30 am - 5
\\\customerservice\subfold
\\\customerservice\subfold
\\\customerservice\subfold
or
\\\customerservice\ 8:00-8:30 am - 2
\\\customerservice\subfold
\\\customerservice\ 8:30-9:00 am - 1
\\\customerservice\subfold
\\\customerservice\ 9:00-9:30 am - 5
\\\customerservice\subfold
Chris
ASKER
Second one
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Chris you are awesome. Thanks a million, you are saviour
ASKER
Hi Chris
Can I open another question and ask you If have to use this for another Shared Inbox where I have to put his address
Thanks
Can I open another question and ask you If have to use this for another Shared Inbox where I have to put his address
Thanks
Hmmm
I guess it should be doable though it would need a different call I think the overall process will work much the same for the shared inbox. so ask away and someone will answer … the hard bit is done I think and i'll think about it a bit myself
Chris
I guess it should be doable though it would need a different call I think the overall process will work much the same for the shared inbox. so ask away and someone will answer … the hard bit is done I think and i'll think about it a bit myself
Chris
Can you confirm which version of outlook is in use and whether you need to run the script from excel or outlook?
Chris