We have an electronic record of patients clinic letters in the form
123456.doc where 123456 is the patients hospital number (always 6
numeric digits). In general, a second letter on the same patient is
inserted in the patients original word document at the bottom as one
might expect.

When we have had temporary secretarys etc. there has not always been
access to the original documents and so the second and subsequent
letters have been saved with a name of the form 123456a.doc,
123456b.doc etc with the intent that they would subsequently merged.
This has never quite happened and now there are maybe a thousand of
these. They are kept in the same directory as the first letter such
that one patient may have several files.

Would it be possible to write to a macro that would test, for each
patient, where there were additional files for that patient and, if
so, insert them into the first file for that patient?

I used to be able to write macros that could do things like this in
the days of WordPerfect 5.1 and Lotus 123 but VBA is a bit beyond me!!

Thanks

John

***IMPORTANT***
Please do not reply to
This is an antispam address.
Please replace effluent with archway.