Isaac
Lifelong Learner
- Local time
- Today, 05:16
- Joined
- Mar 14, 2017
- Messages
- 10,840
I'm having memory-problems, and would like to see if anyone has any insight or advice plus whether or not I'm remembering this right?
In Outlook 2003, IIRC, we could automate Outlook to our heart's content with little-to-no security prompts.
Beginning after Outlook 2003, it got more difficult - especially if Outlook detects that you don't have an antivirus installed.
Enter things like Redemption, which you can install and it makes available a library to use in VBA that will avoid security prompts.
So if I was facing a project to deploy on a virtual server (Windows 2019 Server), I could, perhaps, choose to install Outlook 2003 (if such a thing can still be found??) and basically save myself a lot of trouble. Right? (I understand CDO is an option, but I kind of want to try it the automating-Outlook-way, as I'm more familiar with how to trap errors and stuff like that).
(My goal here is not a multi-user database. It's going to be mostly a "machine/engine" which will be left running all the time, Access form with timer, that constantly loops through a table of Vendors and 'does' some things - like FTP pushes, file copies locally, and email notifications when/if things go wrong, and also some email notifications to certain vendors containing their file in addition to the FTP push).
Is there any other "cautionary" things I should consider before choosing to install Outlook 2003 in order to automate it without security prompts?
Any reasons why I ought to reconsider or avoid this?
In Outlook 2003, IIRC, we could automate Outlook to our heart's content with little-to-no security prompts.
Beginning after Outlook 2003, it got more difficult - especially if Outlook detects that you don't have an antivirus installed.
Enter things like Redemption, which you can install and it makes available a library to use in VBA that will avoid security prompts.
So if I was facing a project to deploy on a virtual server (Windows 2019 Server), I could, perhaps, choose to install Outlook 2003 (if such a thing can still be found??) and basically save myself a lot of trouble. Right? (I understand CDO is an option, but I kind of want to try it the automating-Outlook-way, as I'm more familiar with how to trap errors and stuff like that).
(My goal here is not a multi-user database. It's going to be mostly a "machine/engine" which will be left running all the time, Access form with timer, that constantly loops through a table of Vendors and 'does' some things - like FTP pushes, file copies locally, and email notifications when/if things go wrong, and also some email notifications to certain vendors containing their file in addition to the FTP push).
Is there any other "cautionary" things I should consider before choosing to install Outlook 2003 in order to automate it without security prompts?
Any reasons why I ought to reconsider or avoid this?