I have a report output generated for each vendor and I want to email
this attachment to the appropriate vendor.

The problem is how can I send a email to each vendor with a attachment
for the DTS email task or the XP_SMTP procedure.

Thanks
Karen

For XP_SMTP_SENDMAIl you have to loop though the resultset and change
the recipients list and send the emails on by one (e.g. with a cursor),
in DTS you have to build a loop programatic structure, there are
samples out there for this, look in google for DTS and loop.

(Its that much easier in SQL2k5 X-) )

HTH, jens Suessmeyer.