Custom printing?

[Mike S]

I've developed a form where employees enter several items (think inventory). One of the fields contains a drop down box where the items are placed into one of several groups. Is there a way to make the form highlight and custom print copies based on those groups?



For instance; Let's say the completed form has 2 items in group A, 1 in group B, and 4 in group C. Is it possible to run a maco, etc. where the form would automatically print a copy for groups a, b, c with those items in the groups highlighted (or the others greyed out). I'd like to see one master form printed, one form w/ group A highlighted, one with group B, etc...


The second half of this question pertains to e-mails and checkboxes. Can the form automatically send an e-mail to designated parties if certain check boxes are checked?