yes, the job works, but the whole point of my trigger is to e-mail me whenever new record gets inserted. i have cursor in the trigger that goes through several...

Ok, we can forget about bulk load, but what if i want to have two records inserted together, how would i show both in the mail?

all of these looks fine, but what if you have multiple rows in inserted table? since this method only sends one (first) inserted row, but in if have multiple inserts...