Appointments from Excel to Outlook

Status
Not open for further replies.
C

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?
 
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.
 
Diane Poremsky said:
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.
Click to expand...

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.
< Outlook Calendar invite | PST file backup >
Similar threads
Thread starter Title Forum Replies Date
M Creating Outlook Appointments from Excel Cells Outlook VBA and Custom Forms 1
A Outlook 365 New Appointments All saved to a 365 default calendar on Mac Using Outlook 0
M New Calendar Appointments: Conditionally turn off reminder and show time as free Using Outlook 14
Kika Melo Outlook Calendar deleted appointments not in Deleted Items folder Using Outlook 3
e_a_g_l_e_p_i Outlook 2021 all appointments not showing in calendar Using Outlook 2
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

Similar threads

Back
Top