Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 93
  • Last Modified:

Populate a word template from Excel

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
Chris Falconer
Asked:
Chris Falconer
  • 2
  • 2
1 Solution
 
KoenChange and Transition ManagerCommented:
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
 
Chris FalconerAuthor Commented:
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
 
KoenChange and Transition ManagerCommented:
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
 
Chris FalconerAuthor Commented:
Never thought about doing this... so much easier than what i was trying!
0
 
Rob HensonFinance AnalystCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now