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
Chris FalconerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
KoenConnect With a Mentor Commented:
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
 
KoenCommented:
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
All Courses

From novice to tech pro — start learning today.