Save messages and attachments for a date range

Status
Not open for further replies.
U

UEpGcnk

My company only lets us keep our e-mail in our inbox for three months, then

they are archived. Retrieving those archives requires the promise of your

first born. I am looking for code that will allow me to enter a date range

and have all the e-mails and attachments saved to my local drive as *.msg

files. I want to be able to perform this action on which ever folder is

active.

Any thoughts?

PJ
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
the active folder is Application.ActiveExplorer.CurrentFolder

Loop through the folder's Items collection, check each item's property

(ReceivedTime, CreationTime, LastModificationTime, or whatever you're

looking for), and for the matching items call the SaveAs method, which is

explained in the VBA help file.

Best regards

Michael Bauer

Am Tue, 14 Apr 2009 09:42:01 -0700 schrieb PJFry:


> My company only lets us keep our e-mail in our inbox for three months,


then
> they are archived. Retrieving those archives requires the promise of your
> first born. I am looking for code that will allow me to enter a date


range
> and have all the e-mails and attachments saved to my local drive as *.msg
> files. I want to be able to perform this action on which ever folder is
> active.

> Any thoughts?

> PJ
 
U

UEpGcnk

The Application.ActiveExplorer.CurrentFolder was the missing piece.

Thanks!

Regards,

PJ

Please rate this post using the vote buttons if it was helpful.

"Michael Bauer " wrote:



> the active folder is Application.ActiveExplorer.CurrentFolder

> Loop through the folder's Items collection, check each item's property
> (ReceivedTime, CreationTime, LastModificationTime, or whatever you're
> looking for), and for the matching items call the SaveAs method, which is
> explained in the VBA help file.

> > Best regards
> Michael Bauer

> > >

> Am Tue, 14 Apr 2009 09:42:01 -0700 schrieb PJFry:
>
> > My company only lets us keep our e-mail in our inbox for three months,

> then
> > they are archived. Retrieving those archives requires the promise of your
> > first born. I am looking for code that will allow me to enter a date

> range
> > and have all the e-mails and attachments saved to my local drive as *.msg
> > files. I want to be able to perform this action on which ever folder is
> > active.
> > Any thoughts?
> > PJ

>
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
Diane Poremsky Save Messages and Attachments to a New Folder New Slipstick.com Articles 0
Diane Poremsky Save Messages and Attachments to a New Folder New Slipstick.com Articles 0
M when I save my messages it saves images as attachments . how can I stop it ? Using Outlook 16
C Linking e-mail messages to Business Contact Manager records does not save the attachments in the ema Using Outlook 1
T Outlook 2010 does not save "sent" messages Using Outlook 1
7 I would like to save my email messages from microsoft outlook to a cdrw. Using Outlook 3
S From Field is blank in sent messages that I set to save to folder other than Sent Items Using Outlook 1
D Prevent popup of "Do you want to save changes?" when closing after opening an appointment to view Outlook VBA and Custom Forms 0
A Unable to save recurring Meeting to Documents folder due to error Using Outlook 2
M Outlook 2013 Script Assistance - Save Opened Link with Subject Added Outlook VBA and Custom Forms 1
R Use an ItemAdd to Save Attachments on Arrival Outlook VBA and Custom Forms 0
W Outlook Calendar does not save view any longer! Using Outlook 3
S automate save the .xlxs file to share Network Using Outlook 1
S save email from excel Outlook VBA and Custom Forms 1
Y Open and Save Hyperlink Files in multiple emails Outlook VBA and Custom Forms 9
9 Outlook 2016 How to save an Outlook attachment to a specific folder then delete the email it came from? Using Outlook 1
O Save attachments using hotkey without changing attributes Outlook VBA and Custom Forms 1
geofferyh Cannot get Macro to SAVE more than one message attachment??? Outlook VBA and Custom Forms 5
N Open & Save VBAProject.Otm using VBA Code Outlook VBA and Custom Forms 1
R VBA | Chosing path to save file Outlook VBA and Custom Forms 1
W Save and rename outlook email attachments to include domain name & date received Outlook VBA and Custom Forms 4
V Change default default save location to Quick Access Using Outlook 1
W Save Outlook attachment in network folder and rename to current date and time Outlook VBA and Custom Forms 18
C Change default "Save Sent Item To" folder Outlook VBA and Custom Forms 9
C Outlook - cannot save subject line changes Using Outlook 2
J Save E-mail attachments in a specific folder Outlook VBA and Custom Forms 0
I Outlook 2016 64bit - on receipt convert emails into PDF and save Outlook VBA and Custom Forms 2
V VB script code to save a specific email attachment from a given email Outlook VBA and Custom Forms 14
C Auto save outlook attachments when email is received Outlook VBA and Custom Forms 1
N editing drafts - won't let me save Using Outlook 12
nathandavies Email Details to Excel & Save as .MSG on one macro - combination of 2 macros Outlook VBA and Custom Forms 3
C Need VBA code to automatically save message outside outlook and add date Outlook VBA and Custom Forms 1
D Save Sent Item to Using Outlook 0
Diane Poremsky Save Selected Email Message as .msg File New Slipstick.com Articles 11
Diane Poremsky Export (Save) Outlook Contact photos New Slipstick.com Articles 0
B Delete/replace old files and save new attachments Using Outlook 1
E Outlook 2016 and Numerous Prompts to Save Emails Using Outlook 3
Diane Poremsky Save Outlook Email as a PDF New Slipstick.com Articles 0
Diane Poremsky Edit and Save Outlook's Read-Only Attachments New Slipstick.com Articles 0
Diane Poremsky Save Attachments to the Hard Drive New Slipstick.com Articles 2
B VBA Help Email that will save as draft and send as attachment Outlook VBA and Custom Forms 3
C Save Subject of Received Email as a String Outlook VBA and Custom Forms 1
C Rule To Save attachments on receipt of email Outlook VBA and Custom Forms 2
O Cannot open or save calendar items Using Outlook 0
Diane Poremsky Choosing the Folder to Save a Sent Message In New Slipstick.com Articles 0
Frédéric Save E mail using different path. Outlook VBA and Custom Forms 24
M Question: Is there a rule that will save email in Windows Explorer Outlook VBA and Custom Forms 3
B Auto Save of Attachments from Multiple Emails and forward attachments to user group Outlook VBA and Custom Forms 1
S using script rule to save attachments on arrival Outlook 2010 Outlook VBA and Custom Forms 9
S Save in folder other than Sent when replying with Quick Steps Using Outlook 5
Similar threads


















































Top