hello,

here is the dilemna: i have a shopping cart site which, upon confirmation of an order, sends an email with the order info to the user and to us (for fulfillment). what i'd like to do is, in addition to the above emails, also send email to the product suppliers - limiting their emails to only the products they supply.
so, for example, jimmy orders 2 items. company X gets an email with the order for their item only, company Y gets one for their item, and jimmy gets one with the entire order for use as a receipt.

what's the best way to get started with something like this? i've created an access2000 query with the necessary info, but i know i'll need to at least double filter the recordsets (for orderID and supplierID) and then create an email script that 'knows' what and where it's supposed to send.

frankly, i'm flumoxed.

dan.