Need help in printing certificate for each listed customer in one time

[migdad]

I have list of customers with four fields for each
Customer name Customer number ID number Status
And I would like to print clearance certificate for each customer in one time as I have to print huge number of certificates every day

I couldn't attach example file

[Trebor76]

Though ideally we would need a sample file (attached by clicking the Go Advanced button), see if this thread that I was a part of helps.

[migdad]

Please check the attached sample file

[Trebor76]

Hi migdad,

As I said to dgc050887 in the thread I linked to in post 2 above, thank you for having one template for the letters instead of separate tabs for each customer.

Refer the attached workbook where Macro1 updates the Customer ID number in cell D7 of the Letters tab for each of the customers listed in the List of Customers tab. Each letter is printed out before moving to the next.

Regards,

Robert