Fax and email from Database

Hi, I already have a database that I created using Access 2000. The database handles our Orders. We sell plants to other growers/nurseries. What we do with the database is enter orders, print order confirmations and different type of reports. But we need to add some additional features: I want to be able to FAX or EMAIL order confirmations based on each Broker's preferences. To do this, a new database needs to be created to link each order with a fax number or email address based on the sales rep that sold that order. Example: I get an order from Broker A, this order was taken by Sales Rep B, and is handled by Customer Service Rep C. Broker A wants me to fax the order confirmation to Customer Service Rep C and email a copy to Sales Rep B. I want to do this with just clicking one button (if possible) :) Also it could happen that Broker A, only wants me to fax a copy of the order to Customer Service Rep C and nothing to Sales Rep B. Or it can also be that Broker A, only wants me to email the confirmation to Sales Rep B and Customer Service Rep C... and no faxes. I would like the email to be a PDF file or TEXT File. Whatever is easier. The subject needs to be inserted automatically (Example: Confirmation for you order 54646). Right now I'm printing each confirmation and faxing it manually, but is very time consuming. If you have any questions, let me know. Thanks! -daniel ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables): a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. ## Platform Access 2000 Windows 2000