Macro for Outlook Calendars - Print two calendars at once!

For some reason Microsoft chose two include the ability to overlay two or more calendars for a single integrated view but never gave us the ability to print them.

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

The result was a combined calendar that printed just like I wanted :)   Thanks again and note there are many other calendar tools/macros at SlipStick as well (http://www.slipstick.com/addins/calendar-tools-addins/calendar-printing-tools-for-outlook/#tools) and of course check out the Whats new area.

Sweet little Excel Macro

I love Microsoft Excel macro's that make your life easier.  I was working on the collection of some data into a typical matrix grid, trying to compare items.  Formatting away getting layouts right and then it dawned on me, that I was going to have to put this grid online...ugh...I have seen the resulting HTML from an Excel save as...yuck.  So a quick search online revealed this little jewel of a macro.

http://www.meadinkent.co.uk/xladvhtml.htm  This macro was originally written by Chris Mead (www.meadinkent.co.uk)

It works clean and simply.  And produces a simple web page with the majority of formatting from Excel in tact.  Here is what it looked like in XLS

And here is what the output looked like in IE

Not to bad! And the HTML was clean and easy to edit for integration or use. The macro may require a bit of VB editing to make it work :) Have fun and enjoy.