Parse outlook appointment in shared calendar to check attachment

Welcome Forums General PowerShell Q&A Parse outlook appointment in shared calendar to check attachment

Viewing 9 reply threads
  • Author
    Posts
    • #272956
      Participant
      Topics: 1
      Replies: 5
      Points: 26
      Rank: Member

      Hi All,

      Maybe based on https://powershell.org/forums/topic/outlook-automatic-export-and-calendar/

      I’d like to create a loop in all appointments of many users (probably 15 actually) shared calendar and extract to excel a list with all appointments which don’t contain an attachment starting with “XX”.

      I didn’t find how to access appointment ‘s attachment…

      If somebody can help the noob I am…

       

      thanks to all

    • #273250
      Participant
      Topics: 8
      Replies: 670
      Points: 2,640
      Helping Hand
      Rank: Community Hero

      What would this list contain? Just the name and date of the appointment?

    • #273394
      Participant
      Topics: 1
      Replies: 5
      Points: 26
      Rank: Member

      Hi Doug,

      Thanks for reading

      I need :

      Person

      Title

      List of attachment filename

      The goal is to verify if attachment filename start with “xx”

      It seems to be very difficult to find info shared calendar objects.

    • #273403
      Participant
      Topics: 8
      Replies: 670
      Points: 2,640
      Helping Hand
      Rank: Community Hero

      You said you wanted appointments where the filename DOES NOT start with XX, please clarify. Also, there may be more than one attachment, what are you planning for those situations?

    • #273430
      Participant
      Topics: 1
      Replies: 5
      Points: 26
      Rank: Member

      no sorry.
      each appointment has one more attachment file.
      One of them is delivery proof (AB.pdf), if it’s not present I have to add it.
      What I want is to verify if each appointment of each shared calendar has an attachment file which name starts with “AB” with .pdf extension (for example).
      Finally I’d like to get an output list in excel (or csv) of all appointments without this “AB.pdf” in attachment with field:
      – Calendar’s owner
      – Appointment’s object
      – Date / Time

      Hope it’s more clear…

      thanks

       

       

       

    • #273448
      Participant
      Topics: 1
      Replies: 5
      Points: 26
      Rank: Member

      In this way I can get all I need except attachment:

       

    • #273565
      Participant
      Topics: 8
      Replies: 670
      Points: 2,640
      Helping Hand
      Rank: Community Hero

      I’m not sure what you mean by “Appointments Object.” Hopefully this will help get you going.

      This example assumes we are looping over the 15 accounts you’re trying to verify stored in the variable $userlist.

      You could also choose to set the organizer property to $_.organizer.

    • #273813
      Participant
      Topics: 1
      Replies: 5
      Points: 26
      Rank: Member

      Hi Doug,

      thanks for that, it works fine.
      I was able to add categories, but I wasn’t able to restrict to only the 30 next days or to add where-object for categories too.
      Here’s what I tried :

      Take care of you.

    • #273840
      Participant
      Topics: 8
      Replies: 670
      Points: 2,640
      Helping Hand
      Rank: Community Hero

      It appears that startdate and enddate are used for saveasical and forwardasical – they both honor the dates set. For what you’re trying to do I’d just go with having powershell filter

      Of course you could save those dates as variables or build parameters – this is just to demonstrate.

    • #273846
      Participant
      Topics: 1
      Replies: 5
      Points: 26
      Rank: Member

      Thanks Doug. A pleasure to learn with you. I ‘ll try to achieve the categories filter by myself.

Viewing 9 reply threads
  • You must be logged in to reply to this topic.