Adding several items to an autogenerator Invoice system

Hi All

First, thank for your help on this,. I was modifying the following code to be able to gather some information from invoice tab to the template and after convert to PDF each invoice

the problem is that if the customer has more than 1 item, the VBA code only take the last one and generate the PDF. Any help to write a code to add all the items under the same invoice number?

file attached for your easy reference. thanks again for your feedback

thanks

Please Login or Register  to view this content.

Any help? thanks