merge 2q with 2q, then 2q with 2r, then merge 2s plus same text in each then same for rows 3,4,5,6,

macropod · #2 09-27-2016, 04:33 PM

It's not clear that you need a mailmerge for this. Regardless, you need to do some more work on your Excel workbook, first. For starters, you have some people attending multiple venues for the same course and others missing out on that course. Formulae can also be used to show which venue each person is attending for a given course - assuming they aren't attending multiple venues for the same course!

Try the attached.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Merge Table Rows	npalmer610	Word VBA	2	02-24-2016 04:44 PM
mail merge multiple rows within a grouping	tracygleghorn	Mail Merge	12	11-12-2015 06:43 AM
Formula that can merge multiple rows with the same ID into one row	Hilwey	Excel	3	07-08-2015 08:50 PM
Mail merge into table with two colums and several rows	kathriiin	Mail Merge	3	03-30-2015 07:06 AM
Mail Merge multiple rows?	ender541	Mail Merge	1	08-21-2012 03:14 PM