calendar invite from another email

[don matteo]

Hello everyone
i am working on a macro to automatically send a calendar invite but i need it to send from another email that i am apart of
lets say the email is test@test.com

is this possible
this is the code i have now

Sub SendMeetingRequest()
    Dim objOL   'As Outlook.Application
    Dim objAppt 'As Outlook.AppointmentItem
    Const olAppointmentItem = 1
    Const olMeeting = 1
     
    Set objOL = CreateObject("Outlook.Application")
    Set objAppt = objOL.CreateItem(olAppointmentItem)
    With objAppt
        .Subject = "My Test Appointment"
        .Start = Now + 1
        .End = DateAdd("h", 1, .Start)
         
        ' make it a meeting request
        .MeetingStatus = olMeeting
        .RequiredAttendees = "someone@somewhere.dom"
        .Display
    End With
     
    Set objAppt = Nothing
    Set objOL = Nothing
End Sub

 

[Logit]

.
All untested here :

https://www.slipstick.com/developer/code-samples/send-email-address-vba/

https://www.rondebruin.nl/win/s1/outlook/account.htm

 

[don matteo]

thank you. i am not too advanced with VBA and i reviewed those sites i still cant get it to work