Outlook Archive to PST Files by Date Range VBA Script?

Not open for further replies.


Outlook version
Outlook 2016 32 bit
Email Account
I hope I've simply overlooked a good option and someone can point me to it. Rather than needing to write up the whole script, here's what I would like to do:
  1. Archive items for every 2 weeks or every month to a PST file for that timeframe.
  2. Ideally, then zip that PST file to a totally separate location
  3. Ensure the archive PST files are not still linked to Outlook at the end of each archive
I currently do this for one email address that is essentially at that point a backup for that address. I manually archive items every quarter (90 days or 3 months).

I have a new address which will be substantially larger, and is really only being used as a backup. That is why I'd like to do this ever 2 weeks to a month, automate it, and zip the backup files.

Is there any even skeleton of a script out there (VBA or otherwise) that could handle this?

Thanks for any references or ideas.

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Are you using AutoArchive or the manual archive method? You really only need to script #2... do you keep adding to the archive.pst or create a new one with each archive? ( its easier to find and manage mail if you have fewer pst files and the data files can hold up to 50 GB of mail - but I'd try to limit it to around 10 Gb. )

i don't think i have a macro or script for #2, but its easy enough to do. AutoArchive can handle #1, the pst should be released after archiving, but if not, that is doable with a script too.

If you wanted to use a macro... Use a Macro to Move Aged Email in Outlook - but i would use AutoArchive.
Not open for further replies.
Thread starter Similar threads Forum Replies Date
D Add data in archive.pst to outlook.pst Using Outlook 4
H Opening .PST archive files in Outlook 2007 Using Outlook 10
L Can outlook rules be run on a archive pst file? Using Outlook 1
R Unable to see my archive.pst in my archive folder outlook 2007 Using Outlook 0
J Outlook doesn't save forwarded message if original is located in an archive PST Using Outlook 2
B User prompted for Archive.pst file location each time they open Outlook Using Outlook 3
H Accessing data in Outlook\archive.pst Using Outlook 2
J why 'Open' pst. data files link only to My Documents? Outlook archive and data files are stored in Local App Using Outlook 1
S Outlook blocked access in archive.pst Using Outlook 8
A Does Outlook import Gmail Archive? Using Outlook 1
skylark53 Archive a single Outlook 2013 folder tree Using Outlook 5
K Change the default Archive location via GPO in Outlook 2010 Using Outlook 3
J Outlook 2007 Archive Using Outlook 1
R [outlook-users] Messages won't archive Using Outlook 5
A Outlook 2007 archive folders and files Using Outlook 10
S Outlook 2010: How do you enable Contacts' Activities to search archive folders Using Outlook 6
D No longer able to Archive Outlook 2007 Using Outlook 1
R Outlook 7 auto-archive Using Outlook 1
L MISSING Archive in Outlook 2007 and WIN XP Prof SP3 Using Outlook 3
E Auto archive does not exist in my outlook 2007. Using Outlook 2
S I want to find stored outlook archived inbox files and folders and they are not in the archive file Using Outlook 2
R Outlook 2007 Archive option not available in File menu Using Outlook 2
T Autoarchive and manual archive options are missing in Outlook 2007 Using Outlook 2
M MS Outlook 2007 - Auto Archive feature removed after MS update Using Outlook 1
S File->Archive menu option has disappeared in Outlook 2007, and AutoArchive settings are also no long Using Outlook 9
J missing auto-archive control in outlook 2007 Using Outlook 8
P Auto Archive function missing from Outlook 2007 Using Outlook 7
P Exchange 2010 - Outlook 2010 : Search in Online Archive not working Exchange Server Administration 3
D Error during auto-archive in Outlook 2007 Using Outlook 1
M Microsoft Outlook 2007 Email go into archive folder Using Outlook 1
K online archive missing Outlook 2010 Using Outlook 11
J Easy archiving certain message in online archive? Outlook 2010 and exchange 2010 sp1 Exchange Server Administration 5
S Outlook Archive/AutoArchive not working Using Outlook 3
C Outlook 2010 will not archive auto or manual Using Outlook 1
K Cannot see online archive with Outlook 2007 / Office 2007 SBE Exchange Server Administration 8
U Option to Archive old emails is missing in Outlook 2007 under Windows 7 Using Outlook 19
M Outlook 2007: Is the archive folder taking up the mail box size? Using Outlook 1
R Outlook Express 6: replacing archive after problem Using Outlook 1
J Auto-Archive Outlook 2003 Using Outlook 2
D Online Archive not showing up in retail version of Outlook 2010 Exchange Server Administration 2
P Archive support for Outlook 2007 Exchange Server Administration 3
S Outlook 2010 Email Archive freezing on Network Drive Using Outlook 1
T Missing sent items from Archive in Outlook 2007 Using Outlook 4
E Microsoft Outlook 2010 Professional Plus Not Showing Exchange 2010 Archive Mailbox folder Exchange Server Administration 4
L Cannot see online archive with Outlook 2010 RTM Exchange Server Administration 9
K Exchange 2010 Archive support Outlook clients? Exchange Server Administration 9
J Outlook 2007 - Archive completes correctly then throws an error Using Outlook 4
M Office 2016 Outlook is forgetting passwords Using Outlook 0
G How to add a folder shortcut to outlook quick access toolbar? Using Outlook 5
W Outlook WAS facebook but there is no info for old accounts Using Outlook 0
Similar threads