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?

See if your needs are met by the solution proposed in the discussion at: http://answers.microsoft.com/en-us/o...d-225324ab6fc6

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Assuming that you are working with Microsoft Excel 2010, you might want to check out online tutorials instead. What you want to do seems to be a bit advanced and you won't find the answers in basic excel trainings, so try taking a step upwards and see where you go.

Hi printchesco,

Why would you assume Excel is involved? The thread is in a Word forum and Excel hasn't even been mentioned.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]