Populate a word template from Excel

Chris Falconer
Chris Falconer used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SDM Mobile
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

Author

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.
KoenSDM Mobile

Commented:
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

Author

Commented:
Never thought about doing this... so much easier than what i was trying!
Rob HensonFinance Analyst

Commented:
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial