Make sure you double check the criteria of the letter before you merge it.
If you have selected more than one criteria, for example Late (L) and also All Late Attendances (L, U) it might show 0 for a student with L codes because they don't have any U codes if you're using the [[AUTH codes]] merge template.
Try putting it to one or the other and then clicking Update before merging again.