I am getting ready to create routes for a large Thanksgiving delivery.
In the past we have printed labels and affixed them to each sheet. However, I wanted to do this in a mail merge. The issue is each "route" could have anywhere between 1 and 5 stops. I don't know how to tell the document to go to the next page when it encounters another route #.
For instance Route 1 might be 1 stop, Route 2 might be 3 stops, Route 4 might be 4 stops and so on. We will have about 120 routes. Each stop needs to include First Name, Last Name, Address, City, Zip, Phone Number, comments and number of meals.
Multiple entries might have the same route so the route column is what would be used to determine when to go to the next page.
Any ideas how to do this?
Bookmarks