I use a web based system in order to order products from my wholesalers and then send an email to the location receiving the stock letting them know what I have ordered. The information on the lines that are ordered is in the format of an HTML table, which is copied from the wholesaler's website using the Table2Clipboard firefox extension (http://dafizilla.sourceforge.net/table2clip/index.php. An example is shown below (I can send you the full actual tables as a private message but don't want to post the information on the internet as it is confidential): Product Pack Price Quantity Total OOS Widgets (Some Details) More details 28 £14.81 10 £148.10 After I send an email to the location, they have to enter the goods received into our stock control system. The stock control system allows for importing of data but since we deal with a number of wholesalers, the product notation is not always the same so we cannot do a straight import based on matching a product code. The format is also not correct. I want to be able to do the following: 1. Convert the email message into a form record by using the replaceAll function and Insert records task. a. NB: Since we are dealing with an order, each table should be treated as an order so perhaps an order number field will need to be created in the form. 2. Convert the form into the correct format. a. By the correct format, I mean the format used by our stock control system. The fields that would be required are: i. Order Date (By default should be the date that the email was sent - though if it is too much work then we can enter manually in step 3) ii. Customer (Manually entered in step three or otherwise taken from the body or subject of the email) iii. PONumber (should be blank at the moment as this will have to be entered once the invoice is received) iv. Product Description (This will have to be a lookup from a matching table that will have to map the notation from wholesaler against the notation in our stock control system). v. Name (Product Code for our stock control system- should be in the matching table as above). 3. Once the form has been put into the correct format, each order needs to be reviewed against the quantities received at the location. So in real life, the guys at the warehouse will check the invoice and mark the quantities received. I will still do this but then when it comes to entering into the stock control system, I want the clerk to pull up the order (they will be able to tell from the customer) and confirm the quantities (Note: they should be able to modify them). They should also verify the order date and also the Customer and PONumber. 4. There are normally about 20 invoices to enter a day so there is no point downloading each one at at time as our stock control system allows for import of multiple order. Therefore, there should be a report that we should be able to download as csv that gives a line by line breakdown of all the orders reviewed by the clerk on a particular day. 5. Providing the file is in the correct format, the clerk will then import the data into our stock control system. Message me if you have any questions. Kind regards, Shaheed