Hello,



I'm about to pull out my hair with all of the time I've spent trying to complete this directory mail merge template. I've followed macropod's documentation and countless other tutorials on the web without success.

Attached, I have a template and a data sample. Each person that receives a letter will have at least one custody code, but nearly all will have multiple custody codes assigned to their name. With each change in custodian name, I want the merge to list all custody codes for that individual within that custodian's single letter.

I was able to get this to partially function with providing all custody codes for each individual, but then when I built out the letter with additional information immediately after the custody codes are displayed, my merge no longer listed all custody codes per individual in one letter.

I also want a page break after each letter so I can then split them out and save individually by macro. I don't anticipate having trouble with the macro, but I am having all kinds of trouble simply getting the mail merge template coded correctly. Any help is greatly appreciated.

Thank you,
Collin

Attached Files

	Custody Codes.xlsx (10.0 KB, 11 views)
	Notice - Physical Inventory 001.docx (25.3 KB, 13 views)