The following SQL statement can be entered into a user defined trigger in trigger setup.  In this example it pulls the following details for all parts to be purchased and assigned to buyer “ONE”: Part number, buyer, required qty, required date, and AVL info.

SELECT mrplistview.part_no, mrpinvt.buyer_type, mrpact.reqqty, mrpact.reqdate, mrpact.prefavl FROM (mrplistview INNER JOIN mrpinvt ON mrplistview.uniq_key = mrpinvt.uniq_key) INNER JOIN mrpact ON mrplistview.uniq_key = mrpact.uniq_key WHERE (((mrpinvt.buyer_type)="ONE"))

You can modify it as needed to suit your needs.  Of course it sends an email with the selected info in the body of the email.