Designing Reports from Outlook Calendar

[devlei]

What options are available when designing reports for a Calendar
folder?

I use Calendar as a record keeping tool and need customized reports
that the standard Outlook Views/Printouts cannot provide.

I have written the reports into Excel, and printed them from there, but
I would like people who maybe don't have Excel to also be able to print
them.

Is converting them to html an option? Any links to examples of how to
do this?

With thanks
Dave

 

[Michael Bauer]

Hi Dave,

instead of copying data into an Excel Spreadsheet you can easily copy
them into an html table.

This sample builds a string for a table with three rows each with two
columns:

Private Sub CreateTable()
Dim i As Long
Dim sTable As String
sTable="<table"
For i=1 to 3
sTable=sTable & TableAddRow("value" & i, "value" & i)
Next
sTable="</table"
End Sub

Private Function TableAddRow(col1 As String, col2 As String) As String
TableAddRow="<tr><td>" & col1 & "</td><td> & col2 & </td></tr>"
End Function

The string sTable has to be inserted in a string for the HTML-Document.
The HTML document format you can find via google. The whole string then
needs to be saved as a file.

 

[Sue Mosher [MVP-Outlook]]

Another method, if Word is more common than Excel among the people you're
sharing information with, is to use one of the Word calendar printing
macros. See http://www.slipstick.com/addins/calendar.htm#print

 

[devlei]

Thanks for the responses!

I have also tried putting the data into a MultiColumn ListBox, and
using the UserForm.PrintForm method. This works OK, except for
ColumnHeads and alignment issues raised in a previous post, and also
the fact that if the list is longer than one page only what is
currently visible is printed.

How would one set Margins, Page Orientation, Headers/Footers for the
above situation?