3 replies to this topic

[Blinker920]

Hi,

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.

Thanks,

Blinker 920

[Ed Weber]

Yes, a macro could be written to do what you want but it would be complex enough that you shouldn't expect anybody to program this without payment. I am too involved with other work to do the programming.

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.

[14tonks]

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?

[Blinker920]

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.

Blinker920