Out of Office Assistant

This sounds like me. I am rarely “off” because my hours are very flexible. I have work that needs to be done and its left up to me to get it done by a specific deadline.

Sounds weird to people because I can be working at say 11pm on a Friday, or 2pm on a Saturday just analysing some runs that have just been completed.

Hours work out in the end (week-wise) but its pretty up and down.

I used to let people contact me on vacation if something urgent came up but my wife got annoyed one time a major issue came up and I had to work like 50% of that vacation solving it. Now I just put a full block on my time (this has now become a directive from HR to everybody as people were starting to burn out and they insisted on people taking real time off. They track this via employee surveys)

No kidding. I think I would have to have been off for 6 months or more to have 400 unread emails upon my return. :slight_smile:

We should have a poll. I think I would have to be out maybe at most a month? Assuming emails would trail off after a while.

A work benefit that should be much more common

1 Like

Except in crunch time, I tend to work 2-4 hours in the morning, and another 2-4 hours at night, 6-7 days a week. Some weeks it’s fewer hours, and some weeks, it’s a longer slog.

It’s worked well for me for a while, but it really became smooth when I started mostly working with folks outside North America. Time zones end up not being that big a deal for me.

I’m glad company policy tolerates this, and I’m thankful to have an interesting role where this makes sense, given everything else that goes on with me and mine.

1 Like

Actually, that wouldn’t work because we have 90 day retention policy and emails that are not moved out of your in box will be deleted after 90 days.

1 Like

That’s really short. How do you remember how you did your yearly projects last year? Let alone a semiannual report.

I say milk it. You can probably claim 2 or 3 days of low productivity due to catching up on emails.

If you file your emails into folders the folders have a 2 year retention limit. If you need to hold on to something longer than that, you need to copy it out of the mail system. But I am horrible at filing and orginizing so I simply have a backup inbox and sent box and every 90 days I copy everything from my inbox and sent box into those. Then after 2 years it goes away.

I used to have a steel trap memory and could find things on my very messy desk (before email) then in my email box. Once in about 2012, I dug up an email from a consulting actuary, that I had received in 1995 a few months after I had started my job. Finding things within the last 5 years was a regular thing until they deleted all my emails.

Pro-tip: For now, at least, Outlook has VBA.

This code, placed in ThisOutlookSession, is a way to automate running a macro roughly once a day (specifically at the arrival of the first message at least 24 hours after the code last ran):

Private Sub Application_NewMail()
    Dim sLastRun As String
    sLastRun = Format(Now, "ddddd")
    If GetSetting("MyAppName", "Settings", "LastRun", "") = sLastRun Then
        Exit Sub
    End If
    ArchiveMessages
    SaveSetting "MyAppName", "Settings", "LastRun", sLastRun
End Sub

The macro “ArchiveMessages”, stored in a regular module, might look something like this:

Public Sub ArchiveMessages()
        Set fldrInbox = Application.Session.GetDefaultFolder(olFolderInbox)
        Set fldrSent = Application.Session.GetDefaultFolder(olFolderSentMail)
        Set fldrArchiveIn = GetFolder("userid@domain\path\to\archive\in\folder")
        Set fldrArchiveSent = GetFolder("userid@domain\path\to\archive\sent\folder")
        Dim Item As Object
        dtTwoWeeksAgo = DateAdd("d", -14, Now())
        
        For i = fldrInbox.Items.Count To 1 Step -1
            Set Item = fldrInbox.Items.Item(i)
            If (Item.ReceivedTime < dtTwoWeeksAgo) And (Not Item.UnRead) Then
                Item.Move fldrArchiveIn
            End If
        Next i
        
        For i = fldrSent.Items.Count To 1 Step -1
            Set Item = fldrSent.Items.Item(i)
            Item.Move fldrArchiveSent
        Next i
        
        Set Item = Nothing
        Set fldrInbox = Nothing
        Set fldrSent = Nothing
        Set fldrArchiveIn = Nothing
        Set fldrArchiveSent = Nothing

End Sub

Caution: I edited those macros to remove incriminating/identifying stuff. No guarantees that I didn’t botch something up in the process.

Caution2: New Outlook doesn’t have VBA. At some point, Classic Outlook will go away. Considering just how much I use Outlook’s implementation of VBA to make my life easier, I will be very sad when that happens.

Solution: don’t go on vacation.

I would keep it set like that even when I was in the office.

1 Like

“New” Outlook is trash.

2 Likes

I might just do this today, I’m in a bad mood and I’d rather not be bothered.