Appointments from Excel to Outlook

Status
Not open for further replies.

Chrystel

New Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server 2013
I have the macro that moves an appointment made in Excel to Outlook calendar. My issue is every time I add a new entry in the Excel sheet and run the macro all of the appointments that I have already entered and ran previously in the Excel sheet are repeated in in Outlook calendar again. Is there a way to stop the repeat of appointments?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Outlook doesn't have a duplicate checker for appointments. :( You'd need to filter for each appointment or track the row entry imported and start with the next one.

I think I would add a field to the spreadsheet and add a value to it after the appointment is created - then tell the macro to skip rows with that value. The other option is to set a unique category to the appointments and delete all items in the category then recreate the events.

I might have some code around here that does that - i know i have some that runs on exchange (using web services) - it deletes the appointments in the spacial category and creates more from a csv.
 

Chrystel

New Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server 2013
Outlook doesn't have a duplicate checker for appointments. :( You'd need to filter for each appointment or track the row entry imported and start with the next one.

I think I would add a field to the spreadsheet and add a value to it after the appointment is created - then tell the macro to skip rows with that value. The other option is to set a unique category to the appointments and delete all items in the category then recreate the events.

I might have some code around here that does that - i know i have some that runs on exchange (using web services) - it deletes the appointments in the spacial category and creates more from a csv.

Thanks so much for replying. I am new to this and would not really know how to rework the macro. It would be great if you find the code that you speak of and I may then work the issue out that way. In the mean time I will try the other options that you mentioned.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
M Creating Outlook Appointments from Excel Cells Outlook VBA and Custom Forms 1
S Changing colors of today's appointments, but not recurring ones Using Outlook 33
M Printing Appointments Using Outlook 1
M Calendar daily Appointments and printing Using Outlook 0
C Add Form to Appointments Received, Automatically Outlook VBA and Custom Forms 6
L Option to Show Cancelled Appointments Using Outlook 0
O Export Outlook calendar appointments by filters and date range Outlook VBA and Custom Forms 1
R Outlook 2007 only loads some appointments Using Outlook 0
N Gathering Calendar Appointments from Calendars that synced as Contacts Exchange Server Administration 1
F Year-and-a-day recurring appointments Using Outlook 1
J what file contains contacts, tasks and appointments stored locally? Using Outlook 1
D hiding appointments that are completed or cancelled, how to ? Using Outlook 5
M warning for too many appointments on a same day in Outlook Using Outlook 1
V importing appointments to non-default calendar? Using Outlook 1
OutlookIntegrator Appointments Using Outlook 0
R Make past appointments remain in calendar Using Outlook 1
A Outlook.com changing appointments Using Outlook 8
T populate calendar with appointments and send reminders Using Outlook 1
Diane Poremsky Copy New Appointments to Another Calendar using VBA Using Outlook 0
Diane Poremsky Create Appointments Using Spreadsheet Data Using Outlook 0
Diane Poremsky How to Import Appointments into a Group Calendar Using Outlook 0
I Outlook 2013 Appointments not in HTML Using Outlook.com accounts in Outlook 2
makinmyway Appointments Created in iCloud Calendars Cover Contacts Field...Why? Using Outlook 3
M Expected behaviour of recurring appointments? Using Outlook 2
C Find all deleted recurrence appointments Outlook VBA and Custom Forms 4
M Copy new appointments created in multiple shared calendars to another exchange calendar Outlook VBA and Custom Forms 1
R Outlook calendar appointments Free/Busy time is changing from "Busy" to "Free" Using Outlook 2
G Outlook does not show new appointments in To-Do-Bar Using Outlook 0
A Looping appointments in calendar Outlook VBA and Custom Forms 0
B Outlook Calendar/setting appointments Using Outlook 1
L Appointments disappearing Using Outlook 0
N To do bar - show more than 30 days of appointments Using Outlook 0
A Show ALL of today's appointments in To-Do Bar Using Outlook 1
F Outlook 2007 Calendar Appointments not in Outlook Today view Using Outlook 11
A Can't stop Outlook.com from setting reminders on appointments? Using Outlook.com accounts in Outlook 3
S Outlook 2013 Appointments missing Using Outlook 1
N Outlook Shared appointments automatically to Private Calendar Using Outlook 1
A Synchronize Access Table with Outlook Calendar Appointments Outlook VBA and Custom Forms 3
J Change reminder times of future appointments Using Outlook 1
Mark Rideout Search folder for appointments and emails Using Outlook 2
C Appointments Using Outlook 25
C Appointments Exchange Server Administration 4
I Adding appointments/tasks to other user's calendar Using Outlook 1
R Getting a colleagues appointments and calendar entries Using Outlook 1
N Outlook 2010 Archived Appointments Missing Using Outlook 5
Katrina Fox Missing appointments on calendar even though transferred from old pst Using Outlook 0
Horsepower Setting appointments in calendar Using Outlook 3
W Outlook 2010 - Displaying Private Appointments In Shared Calendars Using Outlook 1
T Synchronize outlook appointments through web application. Using Outlook 1
A OL13 Calendar, won't allow entering 2 appointments consecutively Using Outlook 4

Similar threads

Top