Macro to transfer excel fields into word fields
Posted 16 March 2011 - 07:14 PM
I need a macro to automatically transfer contents of excel spreadsheet e.g. Patient Number, Name, Date of Birth, Referring Physician's Name, etc. from MS excel 2003 spreadsheet into the fields of MS Word 2003 for preparation of the reports. Can that be done and if so if someone can share macro or suggest an easier way than typing the fields all over.
Posted 17 March 2011 - 03:47 AM
If you decided to hire a programmer you will have to provide a great amount of additional information. Also, the word "field" has very specific meanings in both Word and Excel so use the word carefully when describing what you want.
Your best approach might be to split the screen horizontally with Word at the top and Excel at the bottom then copy and paste from Excel to Word.
Posted 17 March 2011 - 07:20 AM
Posted 20 March 2011 - 10:58 AM
If you're doing this to generate a report, is there some reason you can't just use the Excel spreadsheet as the source for a mail merge, set up your Word merge document with the merge fields formatted as you want them, and then just let 'er rip whenever you need a report, setting the merge criteria for the date field, first and last name fields, or whatever you might need to use in order to specify which record/s from the spreadsheet to produce the merge output for?
Thanks for the responses. MailMerge sounds like the best and the easiest. That is what I will use.