Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-05-2014, 10:18 AM
nightale nightale is offline How to extract data from Excel database to create word report for each patient (row) Windows 7 64bit How to extract data from Excel database to create word report for each patient (row) Office 2013
Novice
How to extract data from Excel database to create word report for each patient (row)
 
Join Date: Jul 2014
Posts: 2
nightale is on a distinguished road
Default How to extract data from Excel database to create word report for each patient (row)

Hi guys,



I'm looking for a way to pull some data from my Excel database to create a word report. Basically, each row in Excel equals to one patient. Each column is a variable regarding that patient, i.e. pretty elementary stuff.

I've made a Word template, but I'd like to find a way to automatically populate the data in the Word report so I can print it easily and add it to the file (see the screenshot, it'll be much clearer).

I guess there is some kind of macros that could save me the hassle of manually finding each value for each and every patient, but I'm struggling as to where to start... Am I seeing this the wrong way? Do I need to start from Excel and output the data into a pre-defined template, i.e.the word report?

Any help?

Regards,
Max


Last edited by nightale; 07-06-2014 at 08:46 AM.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to extract data from Excel database to create word report for each patient (row) How to Extract key data from word iliauk Word 3 11-08-2013 04:37 PM
How to extract data from Excel database to create word report for each patient (row) Projects Cash Flow Report in Excel not creating monthly data gardwr Project 2 09-02-2013 09:10 AM
Easy send/save Excel data to Database Table or Stored Procedure TonyHarvard Excel 3 07-11-2012 12:43 PM
How to extract data from Excel database to create word report for each patient (row) How do I dynamically update data in a Word Document from a database table RSchmidt Word 1 07-14-2011 04:27 PM
How to extract data from Excel database to create word report for each patient (row) Create a "report" in MS Word from an Excel file KC3K7 Excel 1 06-04-2009 07:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft