run Outlook from access vba but with different profile and silently
Posted on 2016-09-19
I'm trying to send emails create a rule and then delete a rule all from within Access 2010 vba.
It all works fine as long as I'm logged into a specific profile in Outlook.
Problem: Users may already have Outlook open to a different profile !
The user does not need to be aware of the profile i need them to be in.
But everytime, i log out of outlook , it keeps prompting me to log into outlook with a specific profile.
Set appOutLook = CreateObject("Outlook.Application")
causes me to choose a profile.
I need to
Set appOutLook = CreateObject("Outlook.Application") but open with correct profile...even if they have Outlook open currently to a different profile ?
Is this possible ?