|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
What you're describing is a mailmerge. See:
http://office.microsoft.com/en-us/wo...101857701.aspx http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thank you!
Also, I've managed to get around the 255 columns limit by export my spreadsheet in csv and importing it in the mail merge wizard. Regards, Max |
#4
|
||||
|
||||
Mailmerges with Excel data sources can handle more than 255 columns - the extra just don't show in the helper tools, that's all. So there's no need to use a csv file. If you change the data source back to the Excel workbook, it should continue to work fine.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to Extract key data from word | iliauk | Word | 3 | 11-08-2013 04:37 PM |
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 do I dynamically update data in a Word Document from a database table | RSchmidt | Word | 1 | 07-14-2011 04:27 PM |
Create a "report" in MS Word from an Excel file | KC3K7 | Excel | 1 | 06-04-2009 07:13 AM |