Search results for query: *

Wow got it to work with out password thanks to Caf. You are the man. Actually I combined the code from CAF and GCMOYN. Now I have password, multiple recipients with a group. And it runs in the backround. You guys are the men. Thanks

Does anyone know about this issue. Thanks

Does anyone know how to pass a password from the VB code to the Lotus Database. I want my program to run offline and when it open the mail DB I get prompted for the password. Is it possible to pass the password so as not to be prompted. Thanks.

The same thing happens. It gets hung up. I thought that maybe that was the issue (not quiting Excel and leaving the process running beind the scenes, which is an issue) but when I included the quit statement the same thing happened. I still have the problem with the quit. Thanks.

I do not know how to do this but (and you may already have realized this) try recording a macro and perform the task you are trying to immitate. Then check out the code and tailor it to your needs. I'd try but I dont have anything that uses a text box. Good luck.

Cool the master replied to my Q. Thanks No I can't get back into VBE. The task is running in Task Manager but I can not switch to or access. I can kill task in Task Manager or by ending it in the Scheduler. The simple code I use is this: Sub auto_open() ActiveCell.FormulaR1C1 =...

Ok I know this has been sort of covered but none of the other threads answered my quesitons. Thank you in advance for reading this questions, it is kind of long. I have a macro that I need to run daily when no one is logged on to the workstation (Windows 2000/Windows NT both OS's). I use the...

I have a question to add. How do you send to multiple recipients. I tried for example: strRecipient = "Username1, Username2" but that errored. Any ideas. Also. If you go into a lotus email and click database properties you will find the list of properties (Sendto, Copyto...

GComyn To CC or BCC use MailDoc.copyto = strCC and MailDoc.blindcopyto = strBCC I am sure you can handles all the other places you need to add Dims and stuff. Enjoy.