Import Excel 2007 cell data into word 2007 fields?

[Tec92407]

I have a word 2007 document that is formatted like a template that contains
placeholders. The placeholders map to data in cells contained in an excel
2007 spreadsheet.

I want to automate the replacement of the placeholders with the cell values
in the spreadsheet. The data is arranged in columns on the spreadsheet, and I
want to generate a separate doc for each column of data. What is the best way
to do this?

Thanks

 

[Doug Robbins - Word MVP]

If you were to transpose the data in Excel, you could simply use Mail Merge.



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com