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.
All changes are to the code in the MY form
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.
Sean J says
Do you suggest using this program still in 2021? If not, are there any alternatives?
Diane Poremsky says
I'm not aware of a good replacement - if it works for you, use it. (It didn't work for me in an earlier build of office - from maybe a year or so ago, I have not tested it since.)
Deidra says
I have loved this template for a few years now. However, I am now getting an error code every time I use it. When it goes to Debug, it does nothing. Any suggestions? It's the best template I've found. I have tried uninstalling and reinstalling and have no luck.
Diane Poremsky says
What version of Office are you using? What is the error code?
Debra says
Just found my answer - this is amazing!
Dan says
Debra,
Would you mind sharing how you fixed the issue? I believe I am getting the same issue and I haven't been able to find a resolution.
Thank you!!
Debra says
Thank you for these Word templates for printing Outlook data.
Is there a way to choose a different calendar from Outlook that gets populated into the Word document? It's choosing the calendar attached to my main account and I want to print a different one.
Diane Poremsky says
The one linked on this page should let you choose between your default calendar or the selected calendar (or another user's calendar, if using Exchange). It's all done by code, so any of the calendar templates could be edited to always use the currently selected calendar folder or a specific calendar.
Amy says
When you print a calendar in Daily Style in Outlook 2016, is there a way to print start/end times of each meeting? Also can start/end times show on the calendar itself? I believe we are on Office 365 with Outlook 2016.
Diane Poremsky says
Not really... you'd need to use the agenda style or change the weekly style to print a shorter time period and it will list appt outside of that period with times. Screenshot - https://screencast.com/t/WjG6etlPBiX - double click on the weekly calendar style to bring up the dialog to change the times to print.
The other option would be to use a macro to add the times to the subject or body so they are included.
Frank Doerger says
I appreciate your knowledge and help!
Nifty tool. Any way to quickly and easily print it on legal paper with larger rows and columns?
If not, is there a similar tool to import to Excel because I assume it will be easier to control the "table" size for printing.
Diane Poremsky says
if you choose legal paper, i thought it resizes the printout, but it's been a while since I last testing printing. I don't know of any free tools that use excel, but there is a utility - https://www.wincalendar.com/Outlook-Calendar-Import.htm?s=s1
Elby Cloud says
This is a great utility, but I wonder if there is a way to publish a filtered calendar?
Diane Poremsky says
With this calendar, no. You'd need to create a filtered view then copy the appointments to a new calendar folder to print.