Outlook Archive to PST Files by Date Range VBA Script?

Status
Not open for further replies.

kjv1611

New Member
Outlook version
Outlook 2016 32 bit
Email Account
POP3
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.
 
Status
Not open for further replies.
Similar threads
Thread starter Title 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
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
e_a_g_l_e_p_i Need clarification on 2-Step Verification for Gmail using Outlook 2021 Using Outlook 5
L Opening People Outlook 2021 Using Outlook 0
e_a_g_l_e_p_i Outlook 2021 not letting me setup my Gmail using pop Using Outlook 1
Geldner Problem submitting SPAM using Outlook VBA Form Outlook VBA and Custom Forms 2
P VBA to add email address to Outlook 365 rule Outlook VBA and Custom Forms 0
M Outlook 2016 outlook vba to look into shared mailbox Outlook VBA and Custom Forms 0
P Can no longer sync Outlook with iPhone calendar after iPhone update to 17.1.1 Using Outlook 2
O Outlook - Switch from Exchange to IMAP Using Outlook 0
e_a_g_l_e_p_i Is it possible to have a reminder in Outlook 2021 for every 90 days Using Outlook 3
farrissf Outlook 2016 Optimizing Email Searches in Outlook 2016: Seeking Insights on Quick Search vs Advanced Search Features Using Outlook 0
C Advanced search terms for "Outlook Data File" Using Outlook 1
N Reply to Outlook messages by moving messages to a specific Outlook folder Outlook VBA and Custom Forms 1
O How to find out the domain and server settings that my Outlook is using? Using Outlook 2
A Outlook 365 (OutLook For Mac)Move "On My Computer" Folder Items From Old To New Mac Computer Using Outlook 3
H Integrating Alexa & Outlook Pro 2021 Using Outlook 2
Z Automatically adjust Outlook Reading Pane from bottom to right depending on portrait or landscape window Using Outlook 1
Rupert Dragwater Background colors not saving in Outlook 365 Using Outlook 15
petunia Outlook tasks module sunsetting? Exchange Server Administration 3
G Save emails as msg file from Outlook Web AddIn (Office JS) Outlook VBA and Custom Forms 0
D Outlook VBA forward the selected email to the original sender’s email ID (including the email used in TO, CC Field) from the email chain Outlook VBA and Custom Forms 3
U Outlook 2021 not showing contact cards in Searches Using Outlook 1
C Outlook - Macro to block senders domain - Macro Fix Outlook VBA and Custom Forms 2
H Outlook 365 O365 outlook calendar item editing Using Outlook 1
J Outlook 365 html inline images Using Outlook 0
Rupert Dragwater How to get Outlook 365 to open from websites Using Outlook 5
S Why do I have to close and reopen Outlook for macros to work? Outlook VBA and Custom Forms 2
J Outlook 2021 ScanPST errors (yet again ... sorry): repair button missing Outlook 2021 Using Outlook 0
HarvMan Outlook 365 - Rule to Move an Incoming Message to Another Folder Using Outlook 4
K Moved pst to new computer, now Gmail not coming into Outlook Using Outlook 7
S Email Macros to go to a SHARED Outlook mailbox Draft folder...NOT my personal Outlook Draft folder Using Outlook 2
F Running Scripts in Outlook 2021 Using Outlook 0
Nufc1980 Outlook "Please treat this as private label" auto added to some emails - Help. Using Outlook 3
S Outlook 2019 Custom outlook Add-in using Visual Studio Outlook VBA and Custom Forms 0
V Outlook macros no longer run until VB editor is opened Outlook VBA and Custom Forms 0
R Outlook 365 How to integrate a third-party app with Outlook to track email and sms? Using Outlook 2
e_a_g_l_e_p_i I can't believe what I am seeing when trying to install Outlook 2021 Using Outlook 9
Kika Melo Outlook Calendar deleted appointments not in Deleted Items folder Using Outlook 3
P How to get a QR code for automatic signin with Outlook for iOS Using Outlook 5
J Migrating Outlook Using Outlook 1
Retired Geek Outlook for the MAC with Yahoo accounts now very broken Using Outlook 9
S Outlook 2002- "Send" button has disappeared. Help please. Using Outlook 1

Similar threads

Top