Solved

Populate a word template from Excel

Posted on 2016-10-06
5
74 Views
Last Modified: 2016-10-06
Hi,

I have been looking around for a solution to my problem for sometime and have tried to use Excel2Word! but not had much success. I have attached example data on the file data.xls and an example of the template i want to fill on Template.doc.

The titles of the columns reference the same names as within the template.doc file, I would like a solution where i can populate the word document based on what cells i select from within Excel. For example how would i generate a filled template using information from row 4, 5 or 6 etc.

Thanks,
Chris.
Data.xlsx
Template.docx
0
Comment
Question by:Chris Falconer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 8

Accepted Solution

by:
Koen earned 500 total points
ID: 41831793
does it need to be word?

it's quite easy to just create your template on a new excel sheet (see attached file), just fill in the ID and done...
Data.xlsx
1
 

Author Comment

by:Chris Falconer
ID: 41831834
Doesn't need to be word but im not sure what you mean regarding the new excel sheet.

The only outcome is i need a document i can send to a contact which contains only the information relating to that line in the excel sheet.
0
 
LVL 8

Expert Comment

by:Koen
ID: 41831872
look at the attached file... your second sheet has your document...
save as pdf , or save as single sheet in a new xls, whatever you prefer
1
 

Author Closing Comment

by:Chris Falconer
ID: 41831908
Never thought about doing this... so much easier than what i was trying!
0
 
LVL 33

Expert Comment

by:Rob Henson
ID: 41831910
This is an ideal candidate for Mail Merge.

Running the merge creates a separate document for each record in the excel list. This can then be printed or sent as an email.

Thanks
Rob H
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

635 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question