AUTOMATION FOR SENDING E-MAILS USING OUTLOOK

[Guest]

Hello:

We have a SQL2k table which contains among other columns, e-mail address and
a status column of all the users authorized to access one of our custom web
application.

Assuming that I have an Outlook client installed and configured on the
server where the web application is installed and assuming that there is a
ODBC database connectivity to the SQL2k server to access the table mentioned
above, is there a way I can come up with an automation method (quite possibly
create a VB.NET application .exe which will include necessary code to
implement this logic) where I can send out e-mails to the users listed in the
table mentioned above based on the e-mail address and whose status is shown
as "pending."

I can write the code in VB.NET, but want to confirm whether such an
automation is possible using Outlook and if so, what are the requirements for
making it work inside the code?

Any ideas will be greatly appreciated. Thanks in advance!

Regards,

Victor

 

[Sue Mosher [MVP-Outlook]]

No, Outlook is not suitable to automate from server-based code. Why not use the System.Net.Mail namespace?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

Thanks Sue. I will give it a try.

No, Outlook is not suitable to automate from server-based code. Why not use the System.Net.Mail namespace?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers