Mail merge into word from an excel directory.
I have an excel document with GPs in column A and then a list of their
patients in column B and their details in column C, D etc. Obviously most of
them have multiple patients so they are repeated in Column A.
I need to collate it into a table in word so that each GP gets one document
with all their patients' details listed in a table.
I know how to do a straight mail merge pulling the details from excel but
I'm not sure how to do this.
Does anyone have any ideas??
|