I have a mail merge directory that i've created using MS Word, which pulls data from an excel spreadsheet of project team itineraries. The data is constantly being updated - people quit, locations close, people run over schedule at a stop on the list, and so the reports need to be constantly reprinted.
Does anyone have suggestions for how I might set up the merge to create multiple itineraries broken down by a specific field category - in this case, the team name?
For this example, I might have a hundred locations that get assigned to one of six teams - I want to generate six itineraries with only the dates and locations relevant to each team.
A second problem I have is that the number of rows I need for each directory varies - some teams have more locations assigned to them than others. The spreadsheet data is being constantly changed, and one type of change that sometimes happens is a location gets deleted - so even within team paths, the number of locations could go up or down at any given time.
If there is a better approach to this than using MS Word, I'd also love to hear your thoughts! Thank you.
Does anyone have suggestions for how I might set up the merge to create multiple itineraries broken down by a specific field category - in this case, the team name?
For this example, I might have a hundred locations that get assigned to one of six teams - I want to generate six itineraries with only the dates and locations relevant to each team.
A second problem I have is that the number of rows I need for each directory varies - some teams have more locations assigned to them than others. The spreadsheet data is being constantly changed, and one type of change that sometimes happens is a location gets deleted - so even within team paths, the number of locations could go up or down at any given time.
If there is a better approach to this than using MS Word, I'd also love to hear your thoughts! Thank you.