Hi all,

I need help urgently. I have a macro that opens a excel file and sends itself as attachment through Lotus notes to an user.

If the notes application is on, then the macro works fine, but if the notes application is not running, then it starts the notes application, prompts for the password and then generates a error message saying that the database is not found and stops the macro. even after providing the password.

What I need is that to provide the password for login in Lotus notes should be through the macro.

The process stops and waits for the logon password. I want the macro to give the same and proceed.

Any help will ba appreciated.