A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Advanced Archiving



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old July 10th 06, 02:12 PM posted to microsoft.public.outlook.program_vba
Lamaketta
external usenet poster
 
Posts: 1
Default Advanced Archiving

Hi, I would like to do the following:

I want to keep email in my personal folders for 1 week and the archive
to a .pst file which may or may not already exists.

This .pst file must have the same folders as my personal folders and a
new file for every month has to be created (e.g. June 2006 = 2006_06).

Do I need vba for this or can it be done otherwise?
Does anyone have a code from which I can make a good start?

I can do some things in Excel vba, but wouldn't know where to start in
Outlook.

Thanks for any suggestions!

  #2  
Old July 11th 06, 05:41 AM posted to microsoft.public.outlook.program_vba
Michael Bauer
external usenet poster
 
Posts: 435
Default Advanced Archiving

Am 10 Jul 2006 06:12:17 -0700 schrieb Lamaketta:

You can do that with VBA. If you´re familiar with Excel VBA then you won´t
have problems with OL VBA. All methods etc. you can find in the Object
Browser, from there´s also help available via F1.

In the Application_Startup event you can search items with the Restrict
function or AdvancedSearch. For both an example is available in the help
file. Search for the CreationTime property.

If items are being found then create the folder, loop backwards through the
result collection and the item´s Move function.

The folder´s name would be e.g. Format(Date, "yyyy_mm")

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --


Hi, I would like to do the following:

I want to keep email in my personal folders for 1 week and the archive
to a .pst file which may or may not already exists.

This .pst file must have the same folders as my personal folders and a
new file for every month has to be created (e.g. June 2006 = 2006_06).

Do I need vba for this or can it be done otherwise?
Does anyone have a code from which I can make a good start?

I can do some things in Excel vba, but wouldn't know where to start in
Outlook.

Thanks for any suggestions!

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Advanced Signatures in OE rasmus Outlook Express 0 July 3rd 06 02:03 PM
Advanced Signatures in OE zero Outlook Express 9 June 27th 06 06:27 PM
How do I use either AND or OR in advanced find? WaterMaker Outlook - General Queries 1 June 22nd 06 12:19 AM
Advanced Edit - Signatures Tim W. Outlook - General Queries 1 May 21st 06 11:40 PM
Advanced Calendaring Question [email protected] Outlook - Calandaring 1 May 9th 06 07:34 PM


All times are GMT +1. The time now is 10:37 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.