DTS to email individual recipiants from server 2000 view

[willcope]

I need an Active x script to send emails to addresses that are listed in a view then update a related table with getdate() once the email has been sent.

Basically the view will find the employees in a particular department from employeetbl were that department has updated news from the noticestbl. Then we need to loop through each record of the view sending and updating for each.

the view has these fields:
DepartmentID
EmployeeID
EmployeeName
EmailAddress
NewsSubject
NewsFilePath
NewsSigniture

The email needs to be:
sent from = fixed address
sent to = [EmailAddress]
subject = [DepartementID]": "[NewsSubject]
HTML email body = "fixed greating"[EmployeeName]"<br>[NewsFilePath]....

I currently have a DTS running an active x script that emails the whole view in an html table to an email address and I have been trying unsuccessfully to modify this code to meet my needs.

Any help would be greatly appreciated.

Thanks
William Cope

 

[mrdenny]

You'll need to write a cursor that goes through record by record doing the processing.

You might get a better answer in forum961.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com