Opening Outlook remote desktop

[stu_C]

Hi All
We are currently in the process of moving our Access database to a RD Web Access - RemoteApp and Desktop Connection, it all works as it should apart from using VBA to open Outlook (outside of the remote connection) and create an Email. anyone have any ideas how we can do this?

Unfortunately the security levels do not allow outlook to be opened within the remote access so trying to force it open outside of this remote window,
I currently get a run-time error of '429', ActiveX Component cant create object.

Dim oWo  As Object 'Outlook.Application
    Dim oDoc1 As Object 'Word.Document
    'Set oWd = New Word.Application
    Set myOlApp = CreateObject("Outlook.Application")
    Set myitem = myOlApp.CreateItemFromTemplate(CurrentProject.Path & "\TemplateFiles\PasswordEmail.oft")

    myitem.Subject = UCase("HR RECORDS - " & "[" & [Forms]![FRM_TBLALL_FullDetails].[Form]![LblHRRef])
    myitem.To = UCase([Forms]![FRM_TBLALL_FullDetails]![SFRM_TBLALL_STAFFDetails]![SSFRM_TBLALL_INTERVDetails].[Form]![CmbStaffNo].Column(0))
    myitem.display
    
    myitem.body = "Hello" & Chr(13) & Chr(10) & "You will receive an encrypted report and all relevant files required." & Chr(13) & Chr(10) & _
    "Your encryption password is:" & [Forms]![FRM_TBLALL_FullDetails]![SFRM_TBLALL_STAFFDetails]![SSFRM_TBLALL_INTERVDetails].[Form]![Password] 
 End Function

[Welshgasman]

Crossposted first at https://www.access-programmers.co.uk...esktop.327497/

[stu_C]

Crossposted first at https://www.access-programmers.co.uk...esktop.327497/

Again not sure why this matters, it is on a different site and did not have much luck with help hence posting on here

[Welshgasman]

I will repeat what I stated over on the other site.

Yes, because of that reason.
People will likely be duplicating the same advice and wasting their time not realising it had been offered elsewhere.
I know you have not had any responses yet, on either site, but crossposting etiquette still applies.

[Welshgasman]

Now crossposted at http://www.vbaexpress.com/forum/show...esktop-via-VBA

[stu_C]

Unfortunately if I am not able to get the help I need i will post on other forums ones that are more specific to VBA.

[Welshgasman]

Unfortunately if I am not able to get the help I need i will post on other forums ones that are more specific to VBA.

By all means do, nothing wrong with that, especially as you are not getting any responses, which should tell you something?
However it is still polite to mention where you have crossposted.

If you suddenly get responses from one, again that could be duplicating someone else's efforts?

TBH if you could do what you ask, I would see that as a huge security flaw.
Perhaps that is why you have not had any responses?

Might even be worth asking on a MS forum? If anyone should know, it should be them.