Batch update calendar

Status
Not open for further replies.

ofw62

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Windows 10 x64, Outlook 365 Exchange: I have exported calendar to .csv and imported it into Excel.
There are specific words that I want to replace, but that is across hundreds of entries.
I can update that in Excel, export it to csv and import the file into Outlook.

So far no problem.

I want the existing entries be overwritten by the updated new ones and obviously no duplicates.

Whilst importing there is a screen that says

-Replace duplicates with items imported
-Allow duplicates to be created
-Do not import duplicate items


I may check the last option (do not import...), but am I sure the 'existing' entries be overwritten by new / updated ones (with the amended texts)

Thanks.
 
You'd want to use replace duplicates - but I don't think it will work as they are not duplicates if you edited words.

If the first batch was imported - you could sort by modified date (use a list view) and delete the older items that have the same modified date.

If you exported the entire calendar, use a list view and select all and move the existing items to a new calendar then import this. If you have meetings on your calendar, group or filter by message class and move them back to the calendar or don't move them to begin with.
 
Thanks a lot Diane.
I guess, I'll have to export all to Excel, sort by date and go from there.
It'll probably be a boring job though :)
 
Sorry for getting back on this after such a while. There were some other things that needed to be attended.

Anyway, maybe, altogether to proceed as follows:
- export all calendar entries to a .csv (and make a backup of course)
- then apply changes to the imported csv in Excel
- export to csv
- delete all calendar entries within outlook and import the new ones from the exported csv (quite a few)

Thanks.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
M Batch print without appended trail of repeated e Using Outlook 2
F Send multiple batch tasks to single person Using Outlook 3
Diane Poremsky Batch Import Photos into Outlook Contacts Using Outlook 0
Z Batch Change Folder Views in Outlook 2016 Using Outlook 1
N Triggering batch file from Outlook Using Outlook 1
J Hyperlinks to batch files with parameters Using Outlook 3
P Batch adding text to email subject lines in Outlook Using Outlook 24
P Can no longer sync Outlook with iPhone calendar after iPhone update to 17.1.1 Using Outlook 7
M "Attachment Detacher for Outlook" add in, does it update the server copy of the email? Using Outlook 1
icacream New password won't update Using Outlook 2
Commodore Safe way to add or update holidays; Windows Notifications issue Using Outlook 8
R Outlook 365 update sets delete from server flag Using Outlook 1
V Update new custom field Outlook VBA and Custom Forms 5
P Outlook 2019 UI changes after 20H2 update Using Outlook 1
D Change Microsoft Account password - what to do to update on all devices Using Outlook 4
K can't get custom form to update multiple contacts using VBA Outlook VBA and Custom Forms 3
B Outlook 2016 Retail C2R keeps logging since update? Using Outlook 0
C Not sync folders not found after MS Outlook 365 update Using Outlook 1
W September 2020 - No Default Email Client message after Office Update Using Outlook 1
D.Moore VBA script fail after Office 365 update Using Outlook 8
W April 2020 Office 365 Update - Add-Ons fail after Office 365 Update Using Outlook 6
M Outlook 2010 Problem with OutLook 2010 32 bit, after Windows Auto Update Using Outlook 3
Jennifer Murphy Grant R/W (update) access to a friend Using Outlook 3
L Favorites don't update Using Outlook 1
F Copy and replace not update contact in another pst Using Outlook 0
M Message list font changed after update Using Outlook 2
M Quicken One Step Update Bill Reminders Not Syncing to Outlook Using Outlook 1
O Windows 1803 update : QAT and toolbar changed, language pack gone... Using Outlook 5
J Updating existing entry on shared calendar wants to send update from delegate Using Outlook 0
N Using email notification to update calendar events? Outlook VBA and Custom Forms 4
K Update Appointment category when changed in Excel Using Outlook 3
V Outlook 2003 problem with Windows 10 Creators Update 1709 Using Outlook 0
G Windows Update Causes BCM Database Access Problem? BCM (Business Contact Manager) 4
K Update subject based on text in body Outlook VBA and Custom Forms 3
A Creating Progress Bar or Status Bar Update Outlook VBA and Custom Forms 0
M Recent Update Did not Fix Search Problems Using Outlook 7
R Custom Contact Form how to update when loaded. Outlook VBA and Custom Forms 6
C Update Notes for Meeting Attendees Using Outlook 8
A Attendee Update Outlook Meeting Invite Using Outlook 0
Diane Poremsky Outlook Email Security Update Using Outlook 0
S Task Update coming as email and not updating task Using Outlook 3
Diane Poremsky Remove Office 2013 Update Banner Using Outlook 0
B IMAP folders don't update when Outlook 365 opens Using Outlook 0
J Outlook Macro to Update Sharepoint Excel File Using Outlook 1
Diane Poremsky Task Request Status Update Address Missing Using Outlook 0
CWM550 Importing from Eudora Update Using Outlook 5
Cameron Piper Automatically update custom forms across multiple computers Outlook VBA and Custom Forms 1
M Update field codes when opening Outlook Template Outlook VBA and Custom Forms 2
Bachelle Macro to Update Existing Task from New Email Outlook VBA and Custom Forms 3
I Microsoft Security Update KB3097877 Using Outlook 14

Similar threads

Back
Top