Using Word/Excel 2007
Hello,
I have to set up approx 100 documents based on a template which will have linked data to unique cells within a worksheet. In my original template (1 doc) this was done by going into the spreadsheet copying and pasting Link and Merge Formatting. Each document will have approx 20 links to excel. Instead of manually linking 2,000 fields to cells in 100 different documents, I was going to try to use Mail Merge and have the LINK address as the merge field. (eg. so for product A, lets say I past a link to the price from an excel doc into word. If I toggle the paste link code I get {LINK Excel.Sheet.12 "C:\\Users\\XXXX\\Desktop\\Price.xlsx" "Sheet1!R1C1" \a \f 5 \h \* MERGEFORMAT }, then using formulas I woud right out the code for product B in excel {LINK Excel.Sheet.12 "C:\\Users\\XXXX\\Desktop\\Price.xlsx" "Sheet1!R2C1" \a \f 5 \h \* MERGEFORMAT } and so on...). When I try to do the mail merge I get the {MERGEFIELD "Price"} it will show the address correctly as {LINK Excel.Sheet.12 "C:\\Users\\XXXX\\Desktop\\Price.xlsx" "Sheet1!R1C1" \a \f 5 \h \* MERGEFORMAT} but only as text, and will not show the result of the link as it did when I did the paste link manually. Does any one know how to update the field so the field will show the result of the link?
I tried {LINK {MERGEFIELD "Price"}} and {LINK "{MERGEFIELD "Price"}"} with no luck.
Thanks!
Bookmarks