Exporting Outlook tasks to excel

  • Hi there,


    Problem:
    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


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