Solved

Populate a word template from Excel

Posted on 2016-10-06
5
35 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
  • 2
  • 2
5 Comments
 
LVL 8

Accepted Solution

by:
Koen earned 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Never thought about doing this... so much easier than what i was trying!
0
 
LVL 31

Expert Comment

by:Rob Henson
Comment Utility
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction This tutorial provides instructions on how to properly format your Word document using the inbuilt tools provided. The benefits of using these tools means your documents are more accessible and easily portable to other applications an…
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…
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 …

762 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now