Moving Emails Between Archive Folders

Status
Not open for further replies.
S

Spirit ICT

New Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server 2010
I am new to VBA coding in Outlook and am struggling to follow some of the logic. I'm needing to move around 35,000 emails from an Archive folder "Deleted Items" one at a time to a Archive folder "Deleted." Our system prevents moving a batch of emails, based on size, and I don't want to break the 35,000 down manually. I'd rather have a macro that loops and moves each email one at a time.

I'm starting from scratch so any help would be appreciated.

Thanks in advance!
 
Diane Poremsky

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
This macro can be tweaked to do that - Use a Macro to Move Aged Email in Outlook - assuming the Archive is a pst file, you'll use the second macro, that moves mail to a different data file.

You should just need to change these 3 lines:
Set objSourceFolder = objNamespace.GetDefaultFolder(olFolderDeletedItems)

'Use a folder in a different data file
Set objDestFolder = GetFolderPath("Archive\Deleted Items")

The default is mail older than 7 days - that can be changed to any value you want. 1 would be mail that is older than 24 hours; using 0.5 should work for older than 12 hours but i have not tested it.
If intDateDiff > 1 Then
 
Status
Not open for further replies.
< Outlook creating a folder named: "Unwanted" | Question about address book in Outlook 2010 >
Similar threads
Thread starter Title Forum Replies Date
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
R Moved 6 months worth (approx 1500 emails) lost from moving from TPG inbox to Icloud inbox (folders) Using Outlook 3
J Outlook 2016 Moving IMAP emails to Exchange Using Outlook 1
D Any updates or fixes that would make this code stop working just moving emails to another folder Outlook VBA and Custom Forms 1
B Moving account, contacts & emails to another H/D with MSOutlook Using Outlook 5
D Moving Emails Based on Recipient/Sender Outlook VBA and Custom Forms 4
U Outlook 2010 'freezes' before moving emails Using Outlook 2
C Cant find emails after moving pst Using Outlook 1
H Moving emails in shared mailbox to personal mailbox Exchange Server Administration 0
N Reply to Outlook messages by moving messages to a specific Outlook folder Outlook VBA and Custom Forms 1
P Moving from 2010 to 365 Using Outlook 3
O Moving "tasks" to inbox in Outlook 2016 Using Outlook 1
Abraham Outlook 2013 Lost my folders when moving from PST to IMAP Using Outlook 11
F Moving Outlook to new PC Using Outlook 0
A Moving Public Folders to New Database Exchange Server Administration 3
R Problem moving file “Email folders.pst” to new PC Using Outlook 5
glnz Moving from Outlook 2003 to MS365 Outlook - need basics Using Outlook 4
E Having some trouble with a run-a-script rule (moving mail based on file type) Outlook VBA and Custom Forms 5
F Moving Contacts to New Profile Using Outlook 0
J Moving Imported folder Using Outlook 2
A .restrict results changing after moving to Exchange online Outlook VBA and Custom Forms 0
T I'm thinking about moving from outlook.com to the Outlook I have in my Office 365 Using Outlook 1
S Moving .OST file location unsuccessful! Using Outlook 6
M Moving mail to another folder is much slower than before (Office365) Using Outlook 0
M I'm Having problems Moving Contacts to a New List Using Outlook 8
P Moving Outlook.pst & archive1.pst Using Outlook 3
A Moving archived contents in Outlook 2007 back into working folders Using Outlook 0
Diane Poremsky Moving Deleted Items Using Outlook 0
O Moving .ost file Using Outlook 12
Diane Poremsky Outlook.com is moving to Office 365! Using Outlook 3
Diane Poremsky Check Contacts before moving them to Hotmail Contacts folder Using Outlook 0
V Problem moving folders Using Outlook 4
Diane Poremsky Moving Outlook to a New Computer Using Outlook 0
Diane Poremsky Moving from Outlook Express to Outlook Using Outlook 0
M1ck53 Moving Outlook Using Outlook 9
Diane Poremsky Moving an Outlook offline data file (*.ost) Using Outlook 3
D After Moving or Deleting Open Item - Meeting Requests Using Outlook 4
E Moving autoarchive settings to new computer (Outlook 2007) Using Outlook 1
Nick Truscott Lost custom forms after moving mailbox Outlook VBA and Custom Forms 3
L Moving Message Class email via script and Rule Outlook VBA and Custom Forms 3
R Moving contacts from ICloud back to Outlook 2010 Using Outlook 4
M which Outlook recommended to buy for moving Outlook 2000 versions Contact Data Using Outlook 2
P Moving PST file questions Using Outlook 3
Klaas "To Address" duplicated when moving msg to another folder Using Outlook 2
A Outlook 2013 EAS: moving message causes duplicates Using Outlook 3
C Moving BCM Database to Server Share BCM (Business Contact Manager) 1
A Moving .msg files back into outlook Using Outlook 2
S automatically moving flagged sent e-mail to a special folder Outlook VBA and Custom Forms 1
M moving custom field data between outlook and excel? Using Outlook 4
G Moving "Delete" button on Outlook for Mac Using Outlook 1

Similar threads

Top