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.
Do you suggest using this program still in 2021? If not, are there any alternatives?
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.)
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.
What version of Office are you using? What is the error code?
Just found my answer - this is amazing!
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!!
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.
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.
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.
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.
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.
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
This is a great utility, but I wonder if there is a way to publish a filtered calendar?
With this calendar, no. You'd need to create a filtered view then copy the appointments to a new calendar folder to print.