I'm looking into sending out email messages to different individuals through VBA in AutoCAD, Excel, Word, and Access depending on different criteria. I'm not sure the criteria really matters, but...
It would all be pretty simple...
If a dwg does NOT exist..email drafter
If a .xls does NOT exist..email estimater
If a record in Access does NOT exist..email Parts.
etc.
So my question...Where do I start? What information do I need? Do I need to add any references?
What objects, properties, etc. in Outlook do I need?
Are there better ways to send some message instead of using the company email system?
Since the company email is on an Exch. Server, and that is off site, is there a more secure/stable method to send messages to individuals on the Network?
Thanks in advance for your help....