How to extract data from Excel database to create word report for each patient (row)

[nightale]

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

[macropod]

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

[nightale]

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

[macropod]

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.