Hey guys,
Well, I'm presented with a problem here. My client needs me to create a form, where the user will input the information, and then that information goes to a database. All fair and simple, but then he wants to be able to hit a button, and this data will magically go into a word document that has a specific format and layout that I can't create through CSS/HTML. Anyway, I need to get data from a database/form into a word document. Any ideas? Initially I thought that I'd use CF to make an excel worksheet, and then use mail merge in Word to get the data from the spreadsheet and input it like a mail merge. However, there are only a few mailmerge fields allowed (adress, first name, last name etc.), and I need a lot. So, that idea didn't work. Then I thought that maybe I could just copy it from the excel worksheet that I'd make, and link it. This way, all the application would have to do is overwrite the excel sheet with the correct data, and it would automatically update the fields in the word document. However, this didn't work because everytime I updated the data, it lost all the formatting I wanted, and added line breaks everywhere. I'm looking to make this as automated as possible, so having the user delete the line breaks after every bit of info is not acceptable. So, any ideas? How do I get data from a form, into a word document, with minimal user work? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289860 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
