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
    [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!