Recent content by Chrystel

  1. C

    Appointments from Excel to Outlook

    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.
  2. C

    Appointments from Excel to Outlook

    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...
  3. C

    Appointments

    OMG, finally! Thank you so much. I had not created a subfolder in my calendar! Again THANK YOU SO MUCH! Now back to business!
  4. C

    Appointments

    I don't know what to say anymore.
  5. C

    Appointments

    So sorry, yes Outlook library is referenced now and I am still getting the same error as the above post. See highlight below.
  6. C

    Appointments

  7. C

    Appointments

    Okay, I cleared and reran everything. I now get the following error:
  8. C

    Appointments

    This has already been done. I really cannot understand why this is not working. :(
  9. C

    Appointments

    Public Sub CreateOutlookApptz() Sheets("Sheet1").Select On Error GoTo Err_Execute Dim olApp As Outlook.Application Dim olAppt As Outlook.AppointmentItem Dim blnCreated As Boolean Dim olNs As Outlook.Namespace Dim CalFolder As Outlook.MAPIFolder Dim subFolder As Outlook.MAPIFolder Dim arrCal As...
  10. C

    Appointments

    Thanks so much for helping with this. I have tried the macro again correcting it as you have suggested. No go. The very first line is highlighted by yellow. "Public Sub CreateOutlookApptz()". I am wondering if my Excel spreadsheet/workbook may have the problem in it.
  11. C

    Appointments

    Unfortunately I am not a wiz at this sort of thing and have tried everything that I know to do. The ability to take my excel info and export into my outlook in order to have reminders for appointments would be such a benefit to me. I know that it can be done. I do not understand why all of this...
  12. C

    Appointments

    Pasted below is the entire macro as it gives the error with the first 2 lines highlighted, 1st in yellow and second in blue, no other lines are highlighted: Option Explicit Private Sub CommandButton1_Click() Option Explicit Public Sub CreateOutlookApptz() Sheets("Sheet1").Select On...
  13. C

    Appointments

    Also the following is highlighted when I delete and tried macro again. Yellow highlighted: Private Sub CommandButton1_Click() Blue highlighted: Option Explicit
  14. C

    Appointments

    This is the first highlight in yellow: Public Sub CreateOutlookApptz() This is the second highlight in blue: Dim olApp As Outlook.Application
  15. C

    Appointments

    Okay, I set the reference and the next error I got when trying to run the macro is: Compile error-Invalid inside procedure. Is the script correct for Outlook 2013 & Excel 2013
Top