Copying Data from Exchange to PST file

Status
Not open for further replies.
R

RLN

Regularly, I am copying data manually from Exchange to a .PST file.

(fyi...I am not an MS Exchange Administrator, just a 'user' of

Exchange) I do this because I need my Outlook data available when out

in the field and not connected to the corporate network.

Currently, I am performing the following steps manually in Outlook:

1. Empty contents of Calendar,Contacts, Notes and Tasks folders in

MyBackup.PST

2. Manually dragging the Calendar,Contacts, Notes and Tasks folders

from Exchange to MyBackup.PST

3. Closing down MyBackup.PST file (leaving the "Exchange" side of

Outlook open for normal work)

Since macros cannot be written in Outlook, is there a way to

accomplish this with an Excel Macro and run it from an Excel sheet?

I am a bit unfamiliar with the Outlook object model, so I'm not sure

how it would be coded. Does someone have a code sample?

Thnx.....
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
That'd be too much of code for a sample. VBA is supported in Outlook, so you

can write macros - there's just no macro recorder.

Best regards

Michael Bauer

Am Wed, 13 May 2009 13:22:22 -0700 (PDT) schrieb RLN:


> Regularly, I am copying data manually from Exchange to a .PST file.
> (fyi...I am not an MS Exchange Administrator, just a 'user' of
> Exchange) I do this because I need my Outlook data available when out
> in the field and not connected to the corporate network.

> Currently, I am performing the following steps manually in Outlook:
> 1. Empty contents of Calendar,Contacts, Notes and Tasks folders in
> MyBackup.PST
> 2. Manually dragging the Calendar,Contacts, Notes and Tasks folders
> from Exchange to MyBackup.PST
> 3. Closing down MyBackup.PST file (leaving the "Exchange" side of
> Outlook open for normal work)

> Since macros cannot be written in Outlook, is there a way to
> accomplish this with an Excel Macro and run it from an Excel sheet?
> I am a bit unfamiliar with the Outlook object model, so I'm not sure
> how it would be coded. Does someone have a code sample?

> Thnx.....
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
E Copying data from e-mail attachement to EXCEL file via macro Outlook VBA and Custom Forms 38
B Copying data between atbs in a custom form Outlook VBA and Custom Forms 4
N error when copying outlook data "can not copy: the path too deep" Using Outlook 6
R VBA for copying sent email to current folder under a shared mailbox Outlook VBA and Custom Forms 17
E Copying the whole e-mail body into excel Outlook VBA and Custom Forms 0
T Copying Outlook Account Setup For Desktop App Using Outlook 5
J Outlook - 2013 - Error msg when copying folders from Online Archives to another user's mailbox Using Outlook 0
Thiago Manzano Copying E-mails to a folder on HD Using Outlook 1
Diane Poremsky Mark Sent Items as Read After Copying with a Rule Using Outlook 0
crazyboy Copying BCM database from backed up mounted image to new drive BCM (Business Contact Manager) 2
oliv- Prevent copying shared contacts Outlook VBA and Custom Forms 5
Paul Butticaz Copying Contacts from SharePoint List (connected to Outlook) to another Conacts folder Using Outlook 1
K Outlook 2010 Not responding after IMAP folder deletion or copying. Using Outlook 2
Mary B Outlook 2013: Rule for copying new email to folder & marking that copy as read Using Outlook 1
S Calendar items are not being uploaded to outlook.com after copying Using Outlook.com accounts in Outlook 1
P open reminders missing after copying outlook pst file Using Outlook 2
L Copying Emails using drag and drop Using Outlook 2
O New to Outlook 2013, dealing with copying vs. moving sent items Using Outlook 0
S Recover messages that disappeared when copying to folder Using Outlook 1
S Copying multiple messages to folders and keeping date/time detail Using Outlook 1
D Copying POP3 folders from Inbox to IMAP Inbox in Outlook 2003 Using Outlook 0
M Copying setups for mutiple users Using Outlook 2
T Location and simple copying of emails and settings, OL 2010 and Win 7 64bit. Using Outlook 3
A Copying additional contact fields when chosing "Contact from the same company" Using Outlook 5
A Copying cc email addresses to Excel - does not copy the <joe.bloggs@isp.com> Using Outlook 1
S Search Indexing (Copying Folders) Using Outlook 0
E Copying multiple folders to PST Outlook VBA and Custom Forms 2
R copying a custom view from a public folder and distributing programatically Outlook VBA and Custom Forms 3
N Copying outlook macros between pcs Outlook VBA and Custom Forms 1
V Copying contents from one field to another field Outlook VBA and Custom Forms 6
V Backup Calendar, Contacts, Tasks in an POP3 data file Using Outlook 3
e_a_g_l_e_p_i Changing where data .pst is saved to Using Outlook 3
J Deliver new messages to New or Existing Data File? Using Outlook 2
G Outlook 2016: Want IMAP Data Files on My D: Drive and Not C: Drive Using Outlook 1
T vba extract data from msg file as attachment file of mail message Outlook VBA and Custom Forms 1
D Outlook 2016 Unable to load Outlook data pst file Using Outlook 5
V Form data not sending for some users Outlook VBA and Custom Forms 2
D Outlook VBA error extracting property data from GetRules collection Outlook VBA and Custom Forms 10
J Outlook 2013 Change color of text in data fields of contacts in Outlook 2013? Using Outlook 10
T How can Exchange be configured to sync/push one-way so that the server data can't be affected Exchange Server Administration 0
T Extract Data From Outlook Tasks Using Outlook 0
F outlook.com Exchane Server corrupts data Since September 2019 Using Outlook.com accounts in Outlook 6
T Extract Data From Outlook Tasks Using Outlook 0
E To convert imported data to custom fields in Task list Outlook VBA and Custom Forms 1
R "Can't store Outlook data files under the AppData folder. Please choose another folder." Using Outlook 6
C How to export Outlook data to csv? Using Outlook 0
RBLampert Assigning a newly (re)created e-mail account to a specific .pst data file Using Outlook 2
S newly added shared mailboxes downloading 500GB data a day Exchange Server Administration 1
M Using field names to capture a data element Using Outlook 0
S Custom Form, copy user field data to message body Outlook VBA and Custom Forms 12

Similar threads

Top