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 Using Outlook 3
G Daily Task List for shared calendar Using Outlook 3
e_a_g_l_e_p_i Question about calendar Using Outlook 5
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
Fozzie Bear Shared Calendar For Scheduled Tasks Using Outlook.com accounts in Outlook 2
K Add an entry to a specific calendar Using Outlook 1
F Add a category before "Send an Email When You Add an Appointment to Your Calendar" Outlook VBA and Custom Forms 0
L Synch Outlook 365 calendar with iPhone Using Outlook 0
C Recover calendar Using Outlook 0
R How to prevent corrupted Notes format in Calendar and Contacts Using Outlook 0
L Duplicate calendar entries in Outlook 365 Using Outlook 4
G Stop Outlook 365 adding meetings to calendar Using Outlook 2
Christopher M Outlook 365 HELP! Calendar Craziness! Using Outlook 5
J Event/Meeting in Outlook Does Not Align with SharePoint Calendar Using Outlook 5
Commodore Slow calendar Using Outlook 0
C How to import Outlook calendar? Using Outlook 1
G Add contacts birthday to calendar Using Outlook 4
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
KeithJB iCloud calendar sync only works one way! Using Outlook 3
V Backup Calendar, Contacts, Tasks in an POP3 data file Using Outlook 3
O Unable to make changes to an existing Calendar entry Using Outlook 11
J VBA for outlook to compare and sync between calendar Outlook VBA and Custom Forms 1
A Meeting organizer calendar intermittently drops meeting after delegate sends invite Using Outlook 0
A Meeting organizer calendar intermittently drops meeting after delegate sends invite Exchange Server Administration 0
T Outlook 2010 Cannot edit Calendar entries in OL 2010. Using Outlook 1
M On behalf of not showing on calendar for boss Using Outlook 1
C Outlook 2016 Unable to delete Gmail IMAP calendar Using Outlook 3
A force outlook to default to MY calendar Using Outlook 3
O Carriage Return - Line Feeds - exporting Calendar events Using Outlook 0
K How to share multiple calendar items Using Outlook 1
P Calendar Day View only shows 1 all day event Using Outlook 0
Hobbes Outlook 365 Calendar spreads into second calendar Using Outlook 3
J Macro to Insert a Calendar Outlook VBA and Custom Forms 8
C Tracking Calendar Changes? Using Outlook 1
O Batch update 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
e_a_g_l_e_p_i Is it possible to transfer things from one calendar to another Using Outlook 2
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
O Calendar - Location: what happens when using my own way of entering locations Using Outlook 1
I Outlook is stuck at "Updating Calendar" Using Outlook 1
AmonRa Outlook 365 calendar - too much white space Using Outlook 0

Similar threads

Top