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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

forms, data import excel, generate multiple pages 2
Word 2007 document docx renemed to doc 1
Inserting a Cover Page - Word 2007 8
Wrong (cell) number format when data pulled from xls file to Word 1
Word 2007 Link from Excel Printing Boxes 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Word 2003, Word 2007 and Excel Linking problem 4
mail merge from Excel - need static fields 3

Back
Top