How to incrementally backup a pst file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

a711825 - 27 Mar 2008 21:35 GMT

Hi - I'm a bit of a newb when it comes to VBA - what I want to is this;

I want to temporarily open a 2nd pst file and copy only any changed/new
items from the usual (1st) pst to the 2nd one - so on the first run it would
run through all folders (recreating the folders in the 2nd pst) and then copy
everything it sees, however on the second run it would run through all
folders (recreating any changes to the folders in the 2nd pst) and then copy
only things that do not have a duplicate in the 2nd pst

Any code or ideas would be greatly appreciated

Gary

Reply to this Message

Michael Bauer [MVP - Outlook] - 28 Mar 2008 07:03 GMT

Gary, as you appreciate any ideas, here's mine: Even for a skilled Outlook
developer that's some days of work - and for a newbie probably weeks. You
might think about buying one of the many backup tools that are already
available. Spend maybe 20 or 30 Dollars and enjoy the many saved days.

Signature

Best regards
Michael Bauer - MVP Outlook
Use Outlook Categories? This is Your Tool:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>

Am Thu, 27 Mar 2008 13:35:01 -0700 schrieb a711825:

> Hi - I'm a bit of a newb when it comes to VBA - what I want to is this;
>
[quoted text clipped - 8 lines]
>
> Gary

Reply to this Message

a711825 - 28 Mar 2008 12:13 GMT

Thanks Michael but any code ideas (from anyone !) would be appreciated
because I'm trying to learn outlook VBA anyway so buying a solution would
satisfy a short term need but wouldn't help my long term goal !

The only way I can think of doing it is to look at an item in pst1 and then
compare it every item in pst2 with a true/false flag raised if found and then
repeat for every item in pst1 but that would take an age especially in a
large mailbox and I'm sure there has to be a better way.

Cheers
Gary

Reply to this Message

Michael Bauer [MVP - Outlook] - 30 Mar 2008 08:16 GMT

Basically, that's the way. To speed things up you can use the Redemption
from www.dimastr.com. Also faster than the Outlook object model but not as
powerful as the Redemption and harder to code is the CDO 1.21 library.

You can compare items by the LastModifiedDate. Instead of handling
duplicates I'd probably add a userdefined field to every item and store a
unique ID in it.

This sample demonstrates a recursive loop through Outlook folders:
http://www.vboffice.net/sample.html?mnu=2&pub=6&smp=12&cmd=showitem&lang=en

Signature

Best regards
Michael Bauer - MVP Outlook
Use Outlook Categories? This is Your Tool:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>

Am Fri, 28 Mar 2008 04:13:00 -0700 schrieb a711825:

> Thanks Michael but any code ideas (from anyone !) would be appreciated
> because I'm trying to learn outlook VBA anyway so buying a solution would
[quoted text clipped - 7 lines]
> Cheers
> Gary

Reply to this Message

Rate this thread: