Eureka!
I used the SMTP address which removed the space in the calendar name and it resolved and loaded my test data.
This is a big step forward for me and I am very grateful for your sound advice with this.
Hi, I followed that advice and downloaded the address book via the Send/Receive Groups option.
The VBA doesn't return any errors now however the message box indicates that the shared calendar from the address book still isn't resolved. I may be wrong but this issue could be the way that the...
Hi Diane
Yes your prediction is correct, it did fail and didn't resolve and therefore I'm thinking that maybe it's the way our ICT support set up the shared calendar. It looks like the code would work but the calendar is in some way badly configured. Are there any rules we need to be aware of...
Hi
Changed as suggested - getting closer I think.
Just getting this now:
Latest code
Public Sub CreateOutlookAppointments()
Sheets("Sheet1").Select
On Error GoTo Err_Execute
Dim olApp As Outlook.Application
Dim olAppt As Outlook.AppointmentItem
Dim blnCreated As Boolean...
Hi Diane
I tried the new code and received this error:
This is the revised code in my latest attempt:
Public Sub CreateOutlookAppointments()
Sheets("Sheet1").Select
' On Error GoTo Err_Execute
Dim olApp As Outlook.Application
Dim olAppt As Outlook.AppointmentItem
Dim...
Hi Diane
Thanks very much for getting back to me. I've tried all the suggested ways of connecting to my shared calendar and am currently using the second macro at Create Appointments Using Spreadsheet Data however I'm getting the 'An object could not be found' error when using:
Set Items =...
Hi
I'm building up some VBA based on Diane's examples in
http://www.slipstick.com/developer/create-appointments-spreadsheet-data/ and making good progress. I'm using Excel 2016 and Outlook 2016.
Diane's export VBA from Excel to Outlook works fine with a newly created local calendar under 'My...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.