i'm trying to find ways to cut time by printing customer reports.

i have a template form filled out that gets data from a list of customers along with their personal information.

i have over a thousand customers in which i select a customer number in a drop down box and a vlookup sends the data to the template ready to print. so that works just fine.. choose the customer number from the drop down and my template is ready to print for that customer.

my question is, is it possible in excel to tell the program to print every customer number without having to go through and manually selecting each customer?