Calendar List View Showing Week Number

Status
Not open for further replies.

Ambassador777

Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
I've created a List View of a Outlook 2010 (32-bit) Calendar with a custom field for "Coast" but would also like another custom field to show the WeekNum for the Start Date. How would I go about doing that if possible.
Thanks!
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
You'll need a custom field - could probably do it using VBA, otherwise you'll need to enter the week # yourself (enable incell editing to make it easy).

ok... I'm always up for a fun macro challenge and yes, you can do it using a macro. The VB format date function uses ww to identify the week number using the computer's date.

Format(Appt.Start, "ww")

This will set a week # field on all appointments in the current calendar folder.

Code:
Sub AddWeekNo()
Dim olApp As Outlook.Application

Dim Appt As Outlook.AppointmentItem
Dim sWeek As Long

Set olApp = CreateObject("Outlook.Application")
Set CalFolder = olApp.ActiveExplorer.CurrentFolder

For Each Appt In CalFolder.Items
 On Error Resume Next
 
 sWeek = Format(Appt.Start, "ww")
 Debug.Print sWeek
 Set objProp = Appt.UserProperties.Add("Week No.", olNumber, True)
  objProp.Value = sWeek
  Appt.Save
Next

End Sub
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
P Is there any way of sorting the task list in CALENDAR view? Using Outlook 4
V Lost calendar view, items still in list view Using Outlook 2
S Displaying the Remind Beforehand Value in Calendar List View Using Outlook 2
O Calendar list view in Outlook 2010? Using Outlook 3
G Unable to dismiss reminders from share point list calendar shared in Outlook Using Outlook 2
B ConditionalFormat on <List> items in a Monthly Calendar Calendar Printing Assistant 3
G Daily Task List for shared calendar Using Outlook 3
M Calendar daily Appointments and printing Calendar Printing Assistant 0
I Google Calendar <calendar-notification@google.com> appearing as a duplicate entry Using Outlook 2
L Sharing Calendar for Only Scheduling Using Outlook 2
S Excel VBA and shared calendar issue Outlook VBA and Custom Forms 4
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
J O365 - Adding Shared Google Calendar ICS link issue in O365 Using Outlook 0
B Outlook Calendar not coming down from cloud Using Outlook 2
J Time Zone Issues - Outlook Calendar and Webcal Feed Using Outlook 8
N Backing Up Exchange Calendar Using Outlook 13
N Having Shared Calendar shift to Current day Using Outlook 0
K UDF with formula not showing on Calendar custom view. Outlook VBA and Custom Forms 0
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
U Macro for reminders,tasks,calendar Outlook VBA and Custom Forms 4
O Calendar - appointment templates and categories Using Outlook 1
HarvMan Outlook 365 Calendar Using Outlook 13
A calendar invites sent from Microsoft Outlook to Mac Outlook is not working Calendar Printing Assistant 3
P Categorize in Calendar not listed under tags in Office 365 (Office 2016) Using Outlook 5
O Export Outlook calendar appointments by filters and date range Outlook VBA and Custom Forms 1
J Weekend View in Calendar Using Outlook 1
D Add date next to day name in Outlook Today calendar view Using Outlook 1
A Birthdays from .csv to Calendar - arriving day behind Using Outlook 5
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
L Deleting Office 365 calendar appt w/o emailing invitees Using Outlook 3
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
TomHuckstep Outlook 2016 Limit the number of days syncing from Google Calendar Using Outlook 1
J Outlook 2010 Changing events in Outlook calendar via opening file, importing CSV Using Outlook 0
Jennifer Murphy Add birthdays to calendar Using Outlook 7
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
V iCloud calendar sync problems Using Outlook 13
J Copy to calendar function no longer working in outlook 365 Using Outlook 5
T why are the calendar icons different for different accounts Using Outlook 2
D Can Exchange Admin Center create a pst for users email/contacts/calendar? Exchange Server Administration 0
P OWA Settings->Calendar->Events from Email; Setting changes do not hold Using Outlook 1
W Outlook Calendar does not save view any longer! Using Outlook 3
M move to iCloud not working in outlook calendar Using Outlook 12
C Shading every other week on monthly calendar Using Outlook 4
cricket1001 Problems with calendar syncing Using Outlook 0
cricket1001 Shade non-working days in calendar Using Outlook 0

Similar threads

Top