Capture and push logon ID and password for email

[TomH]

I'm working on a database in which opening the db requires entry into a LogOn window. Some report code runs various queries and then uses the CurrentUser value as part of the report name when created:

sTemp_QryName = "qry tmp " & CurrentUser & " - adhoc"

This works fine.

What I need to do, though, is create the ability to drive email from the database through an AfterUpdate event so that, when certain updates are made, an email alert is sent to the appropriate people. The company uses Outlook Web App (OWA) as their email app. I am able to build a URL string that opens a new email and prepopulates the From:, To:, etc... except for the body of the email, which is problem #1.

Problem #0, though, is that opening OWA requires the entry of a User ID and password. I can get the ID field filled, but can't seem to capture and push the password to the app. I know this is a security issue... but with as many updates as this function may require, forcing the manual entry of the password will frustrate the users and may cause abandonment of this feature. The database user logon is synched up with the user password in other areas, like initial login and OWA email.

I heard the term "Trusted Connection" yesterday and thought that might help. But, I'm not sure. Is anyone familiar with this function?

Any guidance on this is greatly appreciated!!

Tom

 

[DJkarl]

I don't think there is a way to capture or retrieve the password when logging in using the User Level Security in Access. You could create your own pop-up form that asks for the user password again and store it in a variable that you could pass to outlook.