Hi BHD,
I have attached the snip of the message box output. I placed the code right where you showed me to place it.
It has picked the right Template for the Data but then it retains the same Template for the other "Reports" as well.
Hence the question about the loop.
Thanks for the help...