I wouldn't do this in a trigger.
Use the trigger to insert into a table then have a scheduled job which polls the table and does the processing when an entry appears.
In that way you have a record of what's been processed and done hold up/error the system due to email issues.
Cursors never.
DTS - only when needed and never to control.