I would concatenate the body message into a string( e.g strBody) first and then do a sendmail.body = strBody. Then you can use "response.write" the string to see what it looks like, before you attempt to us ethe CDONTS object. If you have an order_id in your order table, I recommend not sending the values across pages, but selecting the values on the same page with the CDONTS. Quicker and less errorprone. Regards Matthias -----Original Message----- From: FayeC [mailto:fayec at canada.com] Sent: Thursday, July 26, 2001 10:17 To: Evolt Subject: [thelist] ASP - Retrieving variables from two different tables. Hi, I have a simple e-com site in ASP (school assignment....nothing fancy) and I have been trying to find a way to allow the "company" know when someone places an order... Right now the cart works just fine but when someone places an order the "company" is not notified of the order which makes the site quite useless.... I made some changes to the cart and included some extra coding on the chaeckout page. Now the information from the table cart is transfered/copied to the table orders before cart is emptied. My problem is that I also added a sendmail on the same page that would send the users information and the products and quantity ordered through email to the "company...although I was successful in retrieving information from the users table, I just can't seem to retrieve information from the orders table. I also get errors retrieving the quantity and I think it's because I need to use the Integer to do so but haven't figured the syntax yet. Anyways.Here is the code I used on my Sendmail: <% Dim sendmail Set sendmail = CreateObject("CDONTS.NewMail") sendmail.to = "fayec at canada.com" sendmail.from = "orders at magazine.com" 'sendmail.cc = "fayec at canada.com" 'sendmail.bcc = "" sendmail.subject = "Order Placed" sendmail.body = "The following user placed an order: " & vbcrlf & "Name:" & firstname & lastname & vbcrlf & "Address:" & street & vbcrlf & "City:" & city & vbcrlf & "Province:" & province & vbcrlf & "Postal code:" & postalcode & vbcrlf & "And he placed the following order: "& vbcrlf & "Product:" & productID & vbcrlf & "Date:" & now() sendmail.send Set sendmail = nothing %> The user's information came from the previous page, which had retrieved the information from the users table. The information is sent just fine but the Product doesn't show on the email and if I add the quantity variable to the string it gives me a major error.... I would appreciate *any* help that can lead me to the right path....I thank you all in advance for any tip, push, help you can give me with this headache..... FayeC --------------------------------------- For unsubscribe and other options, including the Tip Harvester and archive of TheList go to: http://lists.evolt.org Workers of the Web, evolt !