Word and excel for mac mail merge tutorial free

broken image

This is not something that can be easily done with Word's mail merge capabilities, with one exception: You can do it if you are doing a directory-type merge. She wants to 'group' records so she can put all the records for a given individual into a single merge document.

broken image

She notes that if she was using SQL she could use 'GROUP BY' to make sure that all the records of a given individual were grouped together. Erin wants to do a mail merge using source data that is in an Excel worksheet where it is possible for a given individual to have multiple rows of data.