outlook calendar analysis

Status
Not open for further replies.
F

fnets

Member
Outlook version
Outlook 2013 32 bit
Email Account
POP3
I have an outlook calendar and in each day I schedule tasks as follows:

category1,p1,p2,p3
category1,p1,p2,p3
category1,p1,p2,p3
category2,p1,p2,p3
category2,p1,p2,p3
category2,p1,p2,p3
category2,p1,p2,p3
category2,p1,p2,p3
category3,p1,p2,p3
category3,p1,p2,p3

the number in each category can vary day to day as do the values of p1,p2 & p3 in each category.

what I'd like to do is in VBA create a string array for all the tasks in a given period, say 1May18 to 5May18) then sort and analyze the array e.g. total p1 in category2.

can anyone help? (retired C+/C# coder).
 
Status
Not open for further replies.
< How to export voting results using VBA? | Setting font and color used when replying to an email >
Similar threads
Thread starter Title Forum Replies Date
F Sync Outlook Calendar Using Outlook 0
N Best way to sync calendar and contacts between Outlook 365 and Outlook on iPhone Using Outlook 4
H Macro to Delete Duplicate items in Outlook calendar where title is the same and date is the same Outlook VBA and Custom Forms 0
J Emails with .ICS calendar invitations attached don't contents when received in Outlook 365 Using Outlook 6
O Any 3rd party tool that sync (mirror) from Outlook Calendar to Google Calendar? Using Outlook 5
G Outlook 365 My iCloud Outlook doesn’t work after reinstalling Microsoft365 on Windows 10 PC – now I get error message on contacts and calendar Using Outlook 1
P Can no longer sync Outlook with iPhone calendar after iPhone update to 17.1.1 Using Outlook 7
H Outlook 365 O365 outlook calendar item editing Using Outlook 1
Kika Melo Outlook Calendar deleted appointments not in Deleted Items folder Using Outlook 3
icacream Outlook 2021 - Google calendar in the peek Using Outlook 0
e_a_g_l_e_p_i MY Outlook 2021 changed the format of the shortcuts for mail, calendar etc. Using Outlook 10
L Synch Outlook 365 calendar with iPhone Using Outlook 0
L Duplicate calendar entries in Outlook 365 Using Outlook 3
G Stop Outlook 365 adding meetings to calendar Using Outlook 1
J Event/Meeting in Outlook Does Not Align with SharePoint Calendar Using Outlook 5
e_a_g_l_e_p_i Outlook 2021 all appointments not showing in calendar Using Outlook 2
V iCloud calendar problems, Outlook shuts down immediately Using Outlook 2
J VBA for outlook to compare and sync between calendar Outlook VBA and Custom Forms 1
A force outlook to default to MY calendar Using Outlook 3
P Outlook calendar and contacts sync problem-outlook disconnects Using Outlook.com accounts in Outlook 2
HarvMan Toggle between calendar and email in Outlook 365 Using Outlook 12
M Outlook calendar is missing Using Outlook 2
A Any way to make Outlook Calendar invitations look right to Gmail/Google Calendar users? Using Outlook 3
I Outlook is stuck at "Updating Calendar" Using Outlook 1
AmonRa Outlook 365 calendar - too much white space Using Outlook 0
P Outlook 2013 Calendar Archiving Using Outlook 0
E Work uses live accounts for emails for all employees. Can we use the outlook calendar to give the employees an universal work schedule calendar? Using Outlook 1
B Outlook Calendar not coming down from cloud Using Outlook 2
J Time Zone Issues - Outlook Calendar and Webcal Feed Using Outlook 8
M In Outlook Calendar remove the buttons: 'Today' and '<' (Back a day) and '>' (Forward a day) that are below the Ribbon and above the calendar display. Using Outlook 0
HarvMan Outlook 365 Calendar Using Outlook 13
A calendar invites sent from Microsoft Outlook to Mac Outlook is not working Using Outlook 2
O Export Outlook calendar appointments by filters and date range Outlook VBA and Custom Forms 1
D Add date next to day name in Outlook Today calendar view Using Outlook 1
C Put Day of Year into Outlook Calendar Outlook VBA and Custom Forms 2
J can't sync outlook calendar contacts with iphone ipad Using Outlook 4
C Outlook Calendar Using Outlook 1
sahameed82 SharePoint calendar directly open in Outlook Using Outlook 0
D Outlook 2016 Migrate 'On My Computer' (local storage) Calendar from Mac Outlook to Exchange Account Using Outlook 5
J Outlook 2010 Changing events in Outlook calendar via opening file, importing CSV Using Outlook 0
M Creating an RSS Feed **FROM** Outlook 2013 Calendar. Using Outlook 5
K Accentuating today in Outlook calendar month view Using Outlook 2
S outlook 2007 calendar search Using Outlook 6
J Copy to calendar function no longer working in outlook 365 Using Outlook 5
W Outlook Calendar does not save view any longer! Using Outlook 3
M move to iCloud not working in outlook calendar Using Outlook 12
F My hotmail calendar is not syncing with my outlook but my email is Using Outlook 3
T Outlook 2010 Advice on syncing OL2010 Calendar and Outlook app Using Outlook 0
L Time format in Outlook calendar and emails Using Outlook 0
S Outlook 2007 Calendar instant search problem. Windows 7 Using Outlook 4

Similar threads

Back
Top