Hello Everyone,
I am creating a wine manual for work and have entered all my important data to a Microsoft Excel 2007 spreadsheet. What I want to do now is have that Excel data transferred to a Microsoft Word document without me having to manually copy/paste each data entry to a seperate page for each row, as there are 135 wines I must cover.
How do I export data from a Microsoft Excel 2007 spreadsheet to a Microsoft Word 2007 template, each row of data pertaining to its own Word template/page?
I assume I would have to enter data tags in my word document so that Excel can parse those tags with actual data.
Also, even though I am a first time visitor to these forums, I assure you I have used the forum Search function and I have also Googled. The only information I seem to find are guides showing how to Control+C and Control+V a range of data from Excel to Word, which is what I am trying to avoid, or implying the use of XML.
Thanks in advance for any help you can provide! I will be checking this post regularily throughout the next few days.
I am creating a wine manual for work and have entered all my important data to a Microsoft Excel 2007 spreadsheet. What I want to do now is have that Excel data transferred to a Microsoft Word document without me having to manually copy/paste each data entry to a seperate page for each row, as there are 135 wines I must cover.
How do I export data from a Microsoft Excel 2007 spreadsheet to a Microsoft Word 2007 template, each row of data pertaining to its own Word template/page?
I assume I would have to enter data tags in my word document so that Excel can parse those tags with actual data.
Also, even though I am a first time visitor to these forums, I assure you I have used the forum Search function and I have also Googled. The only information I seem to find are guides showing how to Control+C and Control+V a range of data from Excel to Word, which is what I am trying to avoid, or implying the use of XML.
Thanks in advance for any help you can provide! I will be checking this post regularily throughout the next few days.