In the past I have successfully implemented a neat VB AddIn on a couple of BCA’s (both running under NT4 Server). However, I am now tasked with implementing a similar thing on a Windows 2000 Server.
Can I use the Microsoft CDO1.21 Library on a 2000 Server? If not which library should I use to for the VBA to interact with Outlook?
Has anyone implemented Emailing using Outlook on a 2000 Server and if so what if any problems did you run into?
I am not sure about this but I read some time back that MS had issued a patch to Outlook 2000 that stopped any emails to be sent from the account by macros!! Folks, dont pounce on me… I could be wrong but it might be worth your while to search MS site on that as I know guys who ran into probs with their non BO VB apps…
You can also use CDO NTS if you have IIS/SMTP on the machine. With Outlook u need to start a MAPI session…
We are using BCA on Win 2K and it working flawlessly, but it is using Outlook’s MAPI. CDO, you need to write the CDO code using the VBA macro that is available for download in another section of BOB on sample codes off the main menu.
It should be fine either way. CDO is actually better anyway because it releases memory better I am told.
You would need to include the Tools/References CDO Library 1.2.1…in your dll’s list.
Hi Daniels,
Can you share the details of steps on how did you set up the BCA installation NT4.0 server to email the refreshed reports? I plan to do it and we have never tried this. Thanks a lot for all the info you can share. I have seen in other postings the scripts that are available. Since you have done it on NT4.0 , could you post that script too?
(BOB member since 2002-08-19)
I could be wrong 
but it might be worth your while to search MS site on that as I know guys who ran into probs with their non BO VB apps…
(BOB member since 2002-08-22)
(BOB member since 2002-10-17)