I regularly export an outlook calendar from a shared account to a CSV file which is incorporated into an excel dashboard. I want to set up a macro that automatically carries out this export on a daily or weekly basis, so I started by trying to just get a code that carries out the export. I managed to get a VBA code working with the help of MS copilot which exports a CSV file, however it only seems to fully populate the calendar from 2012 for a couple of years, there are inputs from the last couple of years, but not the full daily calendar as it usually exports through the import/ export wizard. I notice that when it is done manually, you are prompted about date ranges and recurring instances being incompatible with CSV, is this something that cannot be done without the wizard compiling it?

I regularly export an outlook calendar from a shared account to a CSV file which is incorporated into an excel dashboard. I want to set up a macro that automatically carries out this export on a daily or weekly basis, so I started by trying to just get a code that carries out the export. I managed to get a VBA code working with the help of MS copilot which exports a CSV file, however it only seems to fully populate the calendar from 2012 for a couple of years, there are inputs from the last couple of years, but not the full daily calendar as it usually exports through the import/ export wizard. I notice that when it is done manually, you are prompted about date ranges and recurring instances being incompatible with CSV, is this something that cannot be done without the wizard compiling it?

I regularly export an outlook calendar from a shared account to a CSV file which is incorporated into an excel dashboard. I want to set up a macro that automatically carries out this export on a daily or weekly basis, so I started by trying to just get a code that carries out the export. I managed to get a VBA code working with the help of MS copilot which exports a CSV file, however it only seems to fully populate the calendar from 2012 for a couple of years, there are inputs from the last couple of years, but not the full daily calendar as it usually exports through the import/ export wizard. I notice that when it is done manually, you are prompted about date ranges and recurring instances being incompatible with CSV, is this something that cannot be done without the wizard compiling it?

I regularly export an outlook calendar from a shared account to a CSV file which is incorporated into an excel dashboard. I want to set up a macro that automatically carries out this export on a daily or weekly basis, so I started by trying to just get a code that carries out the export. I managed to get a VBA code working with the help of MS copilot which exports a CSV file, however it only seems to fully populate the calendar from 2012 for a couple of years, there are inputs from the last couple of years, but not the full daily calendar as it usually exports through the import/ export wizard. I notice that when it is done manually, you are prompted about date ranges and recurring instances being incompatible with CSV, is this something that cannot be done without the wizard compiling it?