I’ve searched and found may posts about sending appointment from excel sheet to outlook.
This Macro “Add_To_Outlook” was found here in forum and working almost perfect.
One thing is not working that Macro has runtime error 438 by “If olApptSearch = olAppointment”.
If I take this out and run Macro twice I will have duplicated appointments.
I am new to VBA so I don't understand half of this code as I copied from excel forum.
Explanation to sheet “1 source”:
Column B (from B2) containing date, column C (from C2) containing subject. This appointments are all day events “AllDayEvent = True” (no starting and no ending time).
How to adjust this excel macro to create appointments in outlook calendar “Schulung” from excel sheet without duplicates?
Please Login or Register to view this content.
Would appreciate any help you can give me on this.
Many thanks in advance