Here is my dilemma: I would like to email a form letter via PDF to different customers. With my first script below, all customers end up with the same form letter (i.e., Customers A...D all receive a letter addressed to Customer D) and the problem with the second script is that all customers ended up with one large PDF that has all of the other customers' names on it. I would like Customer A to receive 1 email with 1 pdf attached that is addressed to Customer A, and so on.

I suspect there is a way to loop through each record to do this, but I am new to looping.

Thanks ahead for help!

Ok, I'm playing around with loops to solve my own problem and this particular loop had unpredictable consequences: e.g., Customers A-D received a PDF for customer A and Customers D-G would receive a PDF for customer G, etc...