Archive

Posts Tagged ‘Outlook’

Printing a page range in Outlook 2007

March 25th, 2008 Mohammad Al-Shami 2 comments

My current employer is switching from FirstClass to Microsoft Exchange. One of the questions I got from an employee was how to make Outlook print the first page of an email. When I went to the print dialog I was surprised that it doesn’t have a page range selection option, which surprised me. Having used Windows since version 3.0 I found that option in all Windows applications.

Anyways, according to Microsoft, you can’t. That’s right, they removed one of the very basic options in email from their flagship email client.

The best alternative I found it is to preview in Internet Explorer and print from there.

Signatures with date fields in Microsoft Outlook

March 3rd, 2008 Mohammad Al-Shami No comments

Ok, so today our CEO said he wanted everybody to stamp their emails with the sending date. It’s very simple to just add the date manually, but as you know, a good engineer is a lazy engineer. So this is how I did it:

Add “$$MYDATE$$” to your signature but without the quotes, then add this simple script to VBA:


Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
    If Item.Class = olMail Then
        Dim Signature As String
        Signature = Format(Now(), "d/m/yyyy")
        Item.HTMLBody = Replace(Item.HTMLBody, "$$MYDATE$$", Signature, , 1)
    End If
End Sub

This should do it. This script will replace $$MYDATE$$ with the current date as soon as you hit the “Send” button. So you will still see “$$MYDATE$$” while you’re typing the message.

Just make sure you lower the macro security to medium.

Hope that helps