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!
 
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
F Sync Outlook Calendar Using Outlook 0
F Show events in Monthly Calendar Using Outlook 3
E Subscribing to another calendar when each party uses Office 365 Family Using Outlook 3
M Retaining old contacts and calendar in new account setup Using Outlook 6
P Email and calendar entry text now shifts right about 3 tabs worth of space Using Outlook 1
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
Fozzie Bear Calendar Events created on iPhone have suddenly start sending invitations to attendees Using Outlook 2
J Set calendar default to 'none' (policy) Exchange Server Administration 3
J Calendar events created on iPhone automatically changing default alert from 'None' to 'Time of Event' Using Outlook.com accounts in Outlook 0
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
G Creating Macro to scrape emails from calendar invite body Outlook VBA and Custom Forms 6
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 7
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 14
J Cannot edit a calendar event received as an invitation Using Outlook 2
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
CWM330 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
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

Similar threads

Back
Top