Link to home
Start Free TrialLog in
Avatar of Sandesh555
Sandesh555Flag for India

asked on

Pop up Message Comes up when VBA code is used to connect with Outlook

Hi Team,

I am tring to modify the email body in Microsfot Outlook.  But each time I try it I get a POP up requestiong for Allow Access for the same.

Now this outlook is set up in a corporate envirnoment and we cannot switch it off.  Is their an alternate to skip this pop message box.

I did hear that the same can be skiped using "Recursion.dll" or by using windows handles.

Please note I am doing my development in Microsoft Excel VBA and modifing the Outlook Emails from their using Outlook MAPI folders option.

Thanks,
Sandesh.
ASKER CERTIFIED SOLUTION
Avatar of zorvek (Kevin Jones)
zorvek (Kevin Jones)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sandesh555

ASKER

Hi Kevin,

I went thought the link provided by you.  I also want to know if we can use Windows handle.  One of my fellow developer had provided this solution long time back.  He cannot be reached now.

Thanks,
Sandesh.
It's possible - that's how Redemption works - but I would use Redemption since it does the hard work for you. I personally have never used the Windows API and I never will as long as I have tools like Redemption.

Kevin
Hi Kevin,

I would still need to know how the apiece works here.  As you see in corporate environment we do not have access to install new apps or add in.

And by the time we have the approval it is almost weeks.
*api
OK, someone else will have to assist you then. I have only worked with the Outlook and Redemption object models.

Kevin
Ok thanks Kevin.