Import Excel 2007 cell data into word 2007 fields?

  • Thread starter Thread starter Tec92407
  • Start date Start date
T

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
 
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
 
Back
Top