Clear Offline (Task) Items using VBA

Not open for further replies.


New Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
I have an Outlook 2013 Task folder which sync's with a SharePoint List.

Sometimes when that SharePoint List is updated (primarily via MS Project 2013 Pro which also sync's to the same SharePoint List) the tasks duplicate in the Outlook Task list view.

After some investigation I have found that the issue relates to Outlook's local caching of a copy of the Tasks and can be solved within Outlook by:

Right Click on the Task Folder-> Properties-> Clear Offline Items ->OK (to confirm local changes loss) -> OK (to acknowledge data removed from .ost file) then re-sync the folder (Shift+F9)

BTW, tried switching off Exchange Caching but that didn't stop the issue. Seems the Offline items are created regardless.

Ideally to remove the risk of individuals causing the SP List and MS Project Plan becoming (regularly) messed up with duplicate tasks I'd like to automate the steps needed into a single button press:

1. Clear Offline Items
2. Sync Tasks list with SP List (effectively download latest golden copy using Shift+F9)
3. User makes any updates changes to Task
4. Commit Changes (another Shift+F9 or more likely another button for committing the changes)

The trouble is I can't find anything on how perform that Clear Offline Items using VBA.

Would appreciate any help anyone is able to provide on how to solve this one.
Not open for further replies.
Thread starter Similar threads Forum Replies Date
B Clear Offline Items (Mail Folder) via VBA Outlook VBA and Custom Forms 1
mikolajek Macro to clear flags? Using Outlook 2
M Clear custom date field after recurrence Outlook VBA and Custom Forms 0
Diane Poremsky Clear Outlook's Most Recently Used lists New Articles 0
K clear categories on Exchange 2003 & Outlook 2003 Exchange Server Administration 1
Z Cannot change Clear Day (stationery) theme font Using Outlook 3
W Trying to clear the find a contact box Using Outlook 4
S Calendar Reminders will not clear Using Outlook 1
M Why did my inbox clear itself? Using Outlook 1
L Clear Deleted Items Automaticly with Retention Policy doesn't work. Exchange Server Administration 3
R problem installing exchange 2010 sp1 -failed due to $error.Clear(); Exchange Server Administration 3
M Can't delete an email that won't clear from the outbox. Outlook 2007 Using Outlook 2
B Outlook 2010 - can't clear Outlook 2003 flags and categories Using Outlook 2
D Follow up flag only displays Set Flag, Clear Flag. Missing Today, Tomorrow, This Week, Next Week, No Using Outlook 2
H Error 4202. How do I clear an invalid entry in Hotmail safe senders list? Using Outlook 4
B Is there a way to make a clear button on custom form? Outlook VBA and Custom Forms 1
D Code to clear certain fields in Outlook Form Outlook VBA and Custom Forms 7
S BCM Not Able to Complete Task - Window won't Clear BCM (Business Contact Manager) 1
D How to clear categories Outlook VBA and Custom Forms 2
R Installation of Client Access role fails on Windows Server 2008 R2 (Execution of: "$error.Clear(); I Exchange Server Administration 15
R How can I access my emails from corrupt offline files of MS Outlook ? Using Outlook 1
hbmiller Outlook for Mac Keeps Dropping Offline Using Outlook 2
soadfan Outlook won't send e-mail when offline Outlook VBA and Custom Forms 19
W Receiving messages in offline mode Outlook VBA and Custom Forms 1
J VBA to switch Outlook online/offline Outlook VBA and Custom Forms 4
T BCM 2010 randmoly going offline BCM (Business Contact Manager) 0
Diane Poremsky Convert an Offline File (.ost) to a Personal File (.pst) New Articles 0
Diane Poremsky Moving an Outlook offline data file (*.ost) New Articles 3
Diane Poremsky Using Offline Sync Filters New Articles 0
A Offline folders password forgotten Using Outlook 2
DBoss Outlook 2013 as offline GMail IMAP Sync Using Outlook 1
2 How to use outlook 2003 calendar in always offline mode Using Outlook 0
Jennifer Murphy Why would I want to send/receive when offline? Using Outlook 0
M Outlook 2010 stuck in Work Offline mode; trouble sending email Using Outlook 1
D how to display email images when "working offline" Using Outlook 3
J Error: 0X8004010F - Microsoft Exchange offline address book Exchange Server Administration 9
J Export custom views from offline OST Exchange Server Administration 4
R Problems sending via POP profile when offline from Exchange Using Outlook 7
R Deleting the offline address book Using Outlook 1
D Unable to open hotmail, error hotmail.ost is not an offline folder file Using Outlook 3
B keeps saying I am offline although I am connected to the internet and the work offline button has be Using Outlook 1
R Microsoft Exchange offline address book Using Outlook 5
O my outlook appears to be permenantly offline following an microsoft download__error 0x800ccc0e Using Outlook 2
H Exchange server 2010 cannot update default offline address book Exchange Server Administration 2
B Creating an Offline Database with Outlook 2007 BCM Using Outlook 1
K Exchange 2007 user can't receive mails without going offline and then online again Using Outlook 8
F Outlook goes offline after changing RPCClientAccessServer parameter on mailbox database Exchange Server Administration 4
N Outlook 2010 Clients can't reply to emails or download offline address book? Hosted Exchange 2007 Using Outlook 5
H outlook offline Exchange Server Administration 3
S offline address book not downloading in outllook 2007 Exchange Server Administration 6
Similar threads