Outlook Automation by Patrik

Create Journal Entry from Calendar Appointment

This function will create a new journal entry based on a calendar appointment.

Sub A2_Create_Journal_From_Calendar()
   ' If you receive a "User-defined type not defined" you are missing the reference to Microsoft Forms 2.0 Object Library. If its not listed, add C:\Windows\System32\FM20.dll or C:\Windows\FM20.dll as a reference. http://www.slipstick.com/developer/code-samples/paste-clipboard-contents-vba/
    
   Set currentExplorer = Application.ActiveExplorer
   Set Selection = currentExplorer.Selection

   Dim objAppointment As Outlook.AppointmentItem
   Dim doClipboard As New DataObject
   Dim textSubject As Variant

   'One and ONLY one message muse be selected
   If Application.ActiveExplorer.Selection.Count <> 1 Then
       MsgBox ("Select one and ONLY one message.")
       Exit Sub
   End If
   
   Set objAppointment = Application.ActiveExplorer.Selection.Item(1)
   textSubject = objAppointment.Subject
   
   Set objFolder = Session.GetDefaultFolder(olFolderJournal)
   Set objItem = objFolder.Items.Add("IPM.Activity")
      
   objItem.Subject = textSubject
   objItem.Duration = objAppointment.Duration
   objItem.Start = objAppointment.Start
   objItem.Type = "Meeting"
   objItem.Categories = objAppointment.Categories
   
   objItem.Save
   objItem.Display

End Sub

Comments (1)

EdwardCix

7/21/2022 4:35:40 PM
Wanna additional income? We’ve got a solution! This opportunity is once in a lifetime! We offer the most powerful absolutely free crypto trading platform available both for a tyro and for a pro here https://movingcancer.info/ to learn how to invest the right way. Join us not to regret about it! The enrollment soon ends!

Leave a Comment

All fields are required. Your email address will not be published.