Calendar List View Showing Week Number

Status
Not open for further replies.
A

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

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.
< Calendar Sharing - From This Date On? | OUTBOX ERROR!!!!! >
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
G Creating Macro to scrape emails from calendar invite body Outlook VBA and Custom Forms 4
U When opening shared Calendar "The set of folders cannot be opened" Using Outlook 0
P Can no longer sync Outlook with iPhone calendar after iPhone update to 17.1.1 Using Outlook 2
P turn off the default "all day" check box in new calendar items. How? Using Outlook 1
A Outlook 365 New Appointments All saved to a 365 default calendar on Mac Using Outlook 0
V Unchecking my calendar and leaving shared one visible Outlook VBA and Custom Forms 1
V VBA Categories unrelated to visible calendar and Visual appointment Categories Outlook VBA and Custom Forms 2
M New Calendar Appointments: Conditionally turn off reminder and show time as free Using Outlook 5
J Cannot edit a calendar event received as an invitation Using Outlook 1
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
P Copying ALL calendar entries from Calender in PST file to IMAP OST file? Using Outlook 1
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 3
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 3
G Stop Outlook 365 adding meetings to calendar Using Outlook 1
CWM550 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 2
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

Similar threads

Top