I have an excel document that lists names of approx 500 employees (one on each row), and other columns contain information about that person. I currently merge this information into a word document, and mail each employee the product of this merge document, and this works well. Each employee also recieves one, of 4 types, of work schedules and cover letters, which I currently print separately and labourously.

Problem: I would like to somehow identify, on the excel spreadsheet, which work schedule and which cover letter each employee should recieve .... and then merge ALL of that into a word document ... so that each employee's work schedule and cover letter become part of the total merge document.

I hope this makes sense, I really need some help with this .... any thoughts ? ... is this doable ?

ice cream