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 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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.