More on the Outlook Calendar Template

The Outlook Calendar Template for Word was designed for the North American short date format (mm/dd/yy). It needs to be modified to work for European users with the dd/mm/yy date format. Many thanks to Roger S., Malmesbury, UK, for providing these notes on how the code for the macros need to be changed.

1. Subroutine CreateMonthlyCalendar()

Change the line which defines argdate as follows:

argdate = "1" & "/" & Trim(cmonth) & "/" & Trim(styear)

2. Subroutine CreateWeeklyCalendar()

Change the line which defines scfirst as follows:

scfirst = "1/" & Str(Month(wstartdate)) & "/" & Str(Year(wstartdate))

3. Subroutine DayName()

Change the line which enters the day as follows:

Selection.TypeText format(calcdate, "ddd d-m")

4. Subroutine Insertappointment()

Change the lines which enter the appointments as follows:

mdaystart = "[" & format(appt.Start, "dd/m") & "]"

mdayend = " - [" & format(appt.End, "dd/m") & "]"

Roger also suggests that you may need to the page layout from Letter to A4.

This page is printer friendly

Home | What's New | Exchange Server | Outlook | Utilities
About Slipstick | Feedback | Privacy Policy | Archived Pages | Link to Us | Advertise

Submit New or Updated Outlook and Exchange Server Utilities

Hosted by Intermedia.net