Jul 29 2008, 01:20 PM
I have a table where the fields are part number, on hand quantity, reorder quantity, and email address. The email address is the person who should get the email when the on hand quantity is equal to or less than the reorder quantity. I would like to run a report of all part numbers that have on hand <= to reorder sorted by email address and then send ONE email to the person showing just the part numbers that that person should be reordering, but I want to make one run for all the email addresses in that table. When I try to do this in the on print event, it says that I cannot send object when the object I am trying to email is the report. Thanks in advance.