Hey Guys,
Due to a new job I have been working with excel and VBA quite a bit lately, and I have to say your site was most appreciated and more than a life saver at times. However, I am lost beyond believe right now. I am trying to have Lotus Notes send out an autmated email, which works fine. I had to get rid of the "save in sent folder" function though, which is a bit unfortunate, but seemed necessary regarding functionality.
Setup:
We have one user logged on two computers, one of the computers is always logged on Lotus Notes, said computer is supposed to run some excel sheets, do some calculations (on a shedule) and send out an email via Notes, which works in Theory.
However, if there is a reminder for an Appointment, which we obviously still want to be popping up on the main Computer, then this reminder would stop the code from working, because it requests the user to click "okay". I am wondering if there is a way to detect a prompt like this, and mimick an "okay" click in case of that reminder being open.
Kind regards,
Fabian
p.s. please don't mind my bad english as it is not my mother tongue.
Due to a new job I have been working with excel and VBA quite a bit lately, and I have to say your site was most appreciated and more than a life saver at times. However, I am lost beyond believe right now. I am trying to have Lotus Notes send out an autmated email, which works fine. I had to get rid of the "save in sent folder" function though, which is a bit unfortunate, but seemed necessary regarding functionality.
Setup:
We have one user logged on two computers, one of the computers is always logged on Lotus Notes, said computer is supposed to run some excel sheets, do some calculations (on a shedule) and send out an email via Notes, which works in Theory.
However, if there is a reminder for an Appointment, which we obviously still want to be popping up on the main Computer, then this reminder would stop the code from working, because it requests the user to click "okay". I am wondering if there is a way to detect a prompt like this, and mimick an "okay" click in case of that reminder being open.
Kind regards,
Fabian
p.s. please don't mind my bad english as it is not my mother tongue.
