RP1America
Technical User
I am creating an Excel database of over 250 products. Each has their own price which changes quarterly. Each also has other varying discriptors (name, type, etc.). EVERY product will end up with its own unique letter. The letters are similar in layout, however, the catch is that depending on the product...some paragraphs may come or go, and some tables may come or go. And with some products, where their letters may indeed share a paragraph, dollar amounts or percentage amounts may vary within the paragraph (i.e. I cannot place a mergefield within a mergefield).
This would all be so simple if MS Word would simply capture MS Excel's text formatting when merging data. Then, I could simply create an entire paragraph of text per product row in Excel, create a Word template that is nothing more than merge fields, and merge it to Word (basically creating the entire letter content from a row in Excel).
Another "ideal" option would be if somehow each product's template letter were somehow stored within the Excel database and you could complete a merge of each row's data into each row's individual (and unique) letter. Rather than only being able to merge data into a single Word document.
I would be willing to take all 250+ letters and simply place merge fields where the true variables (price/percentage) would go, yet still I do not know Excel to merge into completely separate Word documents.
Any feedback would be greatly appreciated!!
Note: I am working with MS Office 2007.
This would all be so simple if MS Word would simply capture MS Excel's text formatting when merging data. Then, I could simply create an entire paragraph of text per product row in Excel, create a Word template that is nothing more than merge fields, and merge it to Word (basically creating the entire letter content from a row in Excel).
Another "ideal" option would be if somehow each product's template letter were somehow stored within the Excel database and you could complete a merge of each row's data into each row's individual (and unique) letter. Rather than only being able to merge data into a single Word document.
I would be willing to take all 250+ letters and simply place merge fields where the true variables (price/percentage) would go, yet still I do not know Excel to merge into completely separate Word documents.
Any feedback would be greatly appreciated!!
Note: I am working with MS Office 2007.