Msg#: 3548846 posted 5:20 pm on Jan 15, 2008 (gmt 0)
Hello everyone, this is my first time posting here at Webmaster World.
I hope someone can help me find a solution to this problem.
I work for a company that handles online orders. When orders come in from our Virtual Cart I have to manually write the order on our sales order form. I have been thinking of ways to automatically take the data and map it to a printable sales sheet.
I can view orders in .csv format for easy importing into MS Excel. Is there anyway to take data from an Excel spreadsheet and put it into fields on a form. The orders are separated into sections like address, part number etc. When I import them to excel they are each in their own cells, I would just need to find a program that can take individual cells and map them to different fields in a form.
Thank you for taking the time to read, and for any advice you can give me.
Msg#: 3548846 posted 2:59 am on Jan 16, 2008 (gmt 0)
Welcome to WebmasterWorld, Kannasu.
I would tend to agree, why not just use the features built-in to your software (Microsoft Word, for instance) to develop a form and then use the "mail merge" or other utilities to process your .csv files? Seems like your best option at this point. If not, the custom code that goes into a project such as this can get costly.