Exporting Outlook tasks to excel

  • Hi there,

    I am a beginner to VBA, after googling I managed to piece together a bit of VBA code to export all outlook tasks into an excel sheet saved onto the desktop.

    What I am struggling with, is trying to restrict the exported tasks within a date range specified (See Filter Attempt 2). Does anyone know how to fix this?

    Notes and code:
    I chose the Restrict method over the find and select method since I heard it's faster when searching through large amounts of data.

    Code extract is here:

  • Re: Exporting Outlook tasks to excel

    After searching around, someone was able to assist me on another site.

    Turns out my syntax was wrong. The correct syntax was as follows

    [FONT=Courier New]"[DueDate] >= '" & strStart & "' AND [DueDate] <= '" & strEnd & "'"[/FONT]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!