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
Retired Geek Outlook for the MAC with Yahoo accounts now very broken Using Outlook 6
S Outlook 2002- "Send" button has disappeared. Help please. Using Outlook 1
L How Stop Outlook Nag Messages Using Outlook 1
TomHuckstep Remove Send/Receive All Folders (IMAP/POP) button from Outlook 365 Ribbon Using Outlook 1
L I Cannot Sign Into My Outlook Account? Outlook VBA and Custom Forms 0
icacream Outlook 2021 - Google calendar in the peek Using Outlook 0
e_a_g_l_e_p_i Question about installing my Gmail account on my iPhone but still getting messages downloaded to my desktop Outlook. Using Outlook 3
F Want to add second email to Outlook for business use Using Outlook 5
kburrows Outlook Email Body Text Disappears/Overlaps, Folders Switch Around when You Hover, Excel Opens Randomly and Runs in the Background - Profile Corrupt? Using Outlook 0
M using excel to sort outlook appointment items Outlook VBA and Custom Forms 4
e_a_g_l_e_p_i MY Outlook 2021 changed the format of the shortcuts for mail, calendar etc. Using Outlook 10
Z Outlook 2021 Outlook new emails notification not working Using Outlook 5
K Changing the Deleted Items location in Outlook 2019 Using Outlook 2
J Outlook 365 Outlook Macro to Sort emails by column "Received" to view the latest email received Outlook VBA and Custom Forms 0
V How to use Comas in a picklist in Outlook forms Outlook VBA and Custom Forms 3
e_a_g_l_e_p_i Question about reinstalling Outlook 2021 Using Outlook 5
A Outlook 365 Outlook (part of 365) now working offline - argh Using Outlook 5
M Outlook Macro to save as Email with a file name format : Date_Timestamp_Sender initial_Email subject Outlook VBA and Custom Forms 0
G LinkedIn tab missing in Outlook 365 (but working in OWA) Using Outlook 0
Jay Freedman Outlook forgets "not junk" marking Using Outlook 0
KurtLass Opening Graphics Attachments in Outlook 2021 Using Outlook 0
P now on office 365 but getting error messages about missing Outlook 2013 cache folders Using Outlook 2
B Outlook config download Outlook VBA and Custom Forms 1
M Short term workaround for when Outlook searching stopped functioning Using Outlook 0
D Outlook 2016 Creating an outlook Macro to select and approve Outlook VBA and Custom Forms 0
L Fetch, edit and forward an email with VBA outlook Outlook VBA and Custom Forms 2
BartH VBA no longer working in Outlook Outlook VBA and Custom Forms 1
L Synch Outlook 365 calendar with iPhone Using Outlook 0
W Can vba(for outlook) do these 2 things or not? Outlook VBA and Custom Forms 2
S Outlook 2016 and Acrobat PDFMaker Office COM Addin Using Outlook 0
M "Attachment Detacher for Outlook" add in, does it update the server copy of the email? Using Outlook 1
M Outlook 365 Rename Outlook Priority Using Outlook 3
R Outlook 2019 accesses POP3 but says its offline (because of IMAP servers?) Using Outlook 0
R Outlook Working off line Using Outlook 0
D Outlook 365 Custom forms field limit? Outlook VBA and Custom Forms 4
W Outlook 2016 MSI - Possible to make work with O365 modern Auth & Win7? Using Outlook 4
T Outlook roaming signatures Using Outlook 4
S Adding a recipient's column to Sent folder in Outlook 2010 Outlook VBA and Custom Forms 1
J Outlook search bar in Office 2021 Professional Using Outlook 1
J PSA: How to create custom keyboard shortcut for "Paste Unformatted Text" in Outlook on Windows Outlook VBA and Custom Forms 1
C How to fix outlook continuing to prompt fo an Exchange password Using Outlook 0

Similar threads

Top