Say, I've an Access table in Access 2013 and they structure is as follows : Name, Surname and Volunteer.
The Name and Surname are repeated exactly but Volunteer changes at each instance ie. for each name and surname there are a number of volunteers. Sample table follows :
Name Surn Volunteer
Peter Smith Harry
Peter Smith Jeff
Peter Smith Archie
William Jones Shaun
William Jones Neville
Say, How can I use Word 2013 Mail Merge to Merge a single document for each unique name with the corresponding Volunteers? I was thinking of creating a 2nd table with the names and joining the two tables with the query as data source for the merge document. Would this work? How do I merge from a query?