Import Outlook calender, adding participants is not working

Sarah Zeng 26 Reputation points
2021-07-05T15:06:47.19+00:00

Dears,
when I try to import outlook calender with the comma seperator template I exported from my existing calender, it is always not working to add any participants(the calender itselft is imported successfully, I can receive the reminder). To be mentioned, I use the email address like ******@qq.com of the participants, who are in the same email organizaiton with me. I want to use this canlender to remind my teams for some irregular but important date in future. Did I miss anything?
I'm looking forward to your answers, thanks so much in advance!

Outlook | Windows | Classic Outlook for Windows | For business
0 comments No comments
{count} votes

Accepted answer
  1. Jade Liang-MSFT 9,986 Reputation points Microsoft Employee
    2021-07-06T06:12:52.54+00:00

    Hi @Sarah Zeng

    when I try to import outlook calender with the comma seperator template I exported from my existing calender

    How did you export the .csv file(via Outlook or others)?

    And what's the version of your Outlook client(File>Office account>About Outlook), please first ensure that you have updated to the latest version.

    According to my tests, I have tried to export a .csv file from my calendar in Outlook 365 version 2106, I could invite other attendees to those items that I imported from my .csv file , and the recipient would receive the meeting invitation and choose accept or decline normally. Here are my detailed steps, please kindly check if there are any differences between mine and yours.

    • Export the calendar item from Outlook(File>open and export> import/export>export to a file>comma separated values>select my calendar>browse or new a csv file>check the field and choose finish> set the date range>ok)

    112041-snipaste-2021-07-06-13-55-12.png

    111988-snipaste-2021-07-06-13-56-08.png

    • Import the csv to my calendar(File>open and export> import/export>import from another program or file> choose comma separated values>browse the file>choose the calendar as importing folder>check the field and choose finish)

    112007-2021-07-06-140107.png

    • Open the item and add attendee(double-click the item>choose Invite attendee option> type the attendee's address>click send)

    111989-2021-07-06-140451.png

    If your steps is same with mine or the issue still exists after you perform same tests, in order to avoid the interference of the orginal .csv file itself, it's recommended to create a new .csv file and re-import it to check if the issue has any differences.

    If your issue has any update, please feel free to post back :)

    Update:
    I understand that you would like to import a .csv file to your calendar only and set the reminder directly for the attendee who is based on your file, is it right? If so, please first understand the premise of setting a reminder for others is sending a meeting invitation to them, and according to my tests , it couldn't send the meeting invitation automatically through importing the .csv file to Outlook only in spite of there's "required attendee" in .csv file, so we need to add the attendee mannually as I mentioned above.

    For your requirement, I think the vba script may be helpful, due to here we mainly focus on general issues on Outlook desktop client and know little about script, if you are interested about it , you could try to research the information about outlook and excel script. Also, when you need relevant assistance about script development, you could also post your script issue in dedicated development forum . I have also researched and tested a lot about it and found a script, which could work when you add an attendee only, for your reference:

    Create .csv like below:
    112463-snipaste-2021-07-07-14-42-51.png

    Run the script in Excel (Alt + F11)(Notice: we need to add the reference to run it via Tools>Reference >check the outlook object ):

    Option Explicit  
      
    Sub AddAppointments()  
      
      Dim myoutlook As Object   
      Dim r As Long  
      Dim myapt As Object   
      
        
      Const olAppointmentItem = 1  
      Const olBusy = 2  
      Const olMeeting = 1  
      
        
      Set myoutlook = CreateObject("Outlook.Application")  
      
        
      r = 2  
      
      Do Until Trim$(Cells(r, 1).Value) = ""  
        Set myapt = myoutlook.CreateItem(olAppointmentItem)  
        With myapt  
          .Subject = Cells(r, 1).Value  
          .Start = Cells(r, 2).Value + Cells(r, 3).Value  
          .Recipients.Add Cells(r, 7).Value  
          .MeetingStatus = olMeeting  
            .BusyStatus = olBusy  
      
          If Cells(r, 6).Value > 0 Then  
            .ReminderSet = True  
            .ReminderMinutesBeforeStart = Cells(r, 6).Value  
          Else  
            .ReminderSet = False  
          End If  
          .Save  
          r = r + 1  
          .Send  
        End With  
      Loop  
    End Sub  
    

    Hope it could be helpful to you.


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.