Enter a VBA Macro!
Thank you SlipStick Systems - Diane Poremsky!
http://www.slipstick.com/outlook/combine-outlook-calendars-print-one/
Works great. Couple of items I changed up for my use was the date range of course and then Busy Status, Categories and Location. This code is all in the Private Sub CopyAppttoPrint()
sFilter = "[Start] >= '" & Date - 7 & "'" & " And [Start] < '" & Date + 67 & "'"
.BusyStatus = itm.BusyStatus
.Categories = itm.Categories 'calName
.Location = itm.Location
No comments:
Post a Comment