Clear Offline (Task) Items using VBA

Status
Not open for further replies.
L

Leadfoot

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.
 
Status
Not open for further replies.
< Automatically send email based on drop-down field? | Can Click to Drag Custom Form Field But Cannot Drop When Designing in Outlook 2007 >
Similar threads
Thread starter Title Forum Replies Date
B Clear Offline Items (Mail Folder) via VBA Outlook VBA and Custom Forms 1
P How to clear out all contacts in iCloud, so I can use iCloud-based sync program Using Outlook 1
R Clear one category when another is chosen Outlook VBA and Custom Forms 1
C-S-R How to clear an Outlook (To Do) Task Flag? Using Outlook 8
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 Using Outlook 0
K clear categories on Exchange 2003 & Outlook 2003 Exchange Server Administration 1
Z Cannot change Clear Day (stationery) theme font Using Outlook 3
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
A Outlook 365 Outlook (part of 365) now working offline - argh Using Outlook 5
R Outlook 2019 accesses POP3 but says its offline (because of IMAP servers?) Using Outlook 0
Commodore Automatic switch between working offline/online Using Outlook 4
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) Using Outlook 0
Diane Poremsky Moving an Outlook offline data file (*.ost) Using Outlook 3
Diane Poremsky Using Offline Sync Filters Using Outlook 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
M Change from working offline to online Using Outlook 2
R BCM 2010 error creating offline copy of shared database BCM (Business Contact Manager) 1
R Need code snippet to read offline PST file Outlook VBA and Custom Forms 1
J Offline database BCM (Business Contact Manager) 1
S Creating Offline Database BCM (Business Contact Manager) 6
S Cannot create offline database BCM (Business Contact Manager) 2
D BCM Offline BCM (Business Contact Manager) 1
I Displaying my Online/Offline Status BCM (Business Contact Manager) 2
J how do I accomplish offline archiving of email? Outlook VBA and Custom Forms 1
E Offline BCM Problem BCM (Business Contact Manager) 1
P How to know Outlook is being started in Offline mode? Outlook VBA and Custom Forms 2
S Is a form published in Org folder accessible offline to users ? Outlook VBA and Custom Forms 1
D offline fatabase on laptop not remembering TASKS dates BCM (Business Contact Manager) 1
M BCM 2007 Can not create Offline Database BCM (Business Contact Manager) 2

Similar threads

Back
Top