Before you all get crazy on me, this is a generic username/password. The only reason it exists is to give some thought of security, I suppose, to those not involved with the program. On with the question...
What I did was build an automated email system that sends emails to certain individuals based on a make-table query and parameters the user can specify in a form. The problem is that the users that will need to send these automatic emails out do not maintain the database (which I inherited) and therefore do not really have any need to know the password. I wanted to be able to have them click on a desktop icon and the form would load as a FE. When they choose their parameters and clicked on "Send Email" the password dialog box comes up. I wanted to be able to automatically populate the "Username" and "Password" fields and then hit <Enter> so that the user does not have to everytime they run the program. Is this possible and any ideas? I tried SendKeys action but could not get it to work putting it both before and after the macro to open the database which prompts for the user/pass info.
Please help!
What I did was build an automated email system that sends emails to certain individuals based on a make-table query and parameters the user can specify in a form. The problem is that the users that will need to send these automatic emails out do not maintain the database (which I inherited) and therefore do not really have any need to know the password. I wanted to be able to have them click on a desktop icon and the form would load as a FE. When they choose their parameters and clicked on "Send Email" the password dialog box comes up. I wanted to be able to automatically populate the "Username" and "Password" fields and then hit <Enter> so that the user does not have to everytime they run the program. Is this possible and any ideas? I tried SendKeys action but could not get it to work putting it both before and after the macro to open the database which prompts for the user/pass info.
Please help!
