Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Using DTS to perform an email mail merge

Author  Topic  gbatta Starting Member 26 Posts Posted - 2006-09-07 : 09:02:09 Does anyone know if it is possible to use a DTS package to query data and then send individual emails to each person in the data like a mail merge? Possibly query the data, export into a spreadsheet, then loop through that data in an ActiveX task and use a Send Mail task? Any thoughts or experiences on this?