i have a big excel file - about 1,000 entries. it's used for logging names of people responsible for the web-pages i keep up to date. there's a review-date set for each page, and so every few months i need to write to each person and ask them to check for accuracy, etc., and let me know of any changes that need to be made.
i'm in the process of putting together a word mail merge document that can suck data out of the excel file. i've got it to work with a single line, but i'm confused about how i can make it work where a person is responsible for several pages. each page will be on a separate line in the excel file, and i expect there is something boolean that i can do, but i can't figure it...
i want it to check if the name in the 'person responsible' field recurs, and if so to insert the merge field again, and if not move onto the next name in the 'person responsible', and generate a new copy of the letter addressed to that name. got it? have i? or am i asking the wrong question?
any help much appreciated!