I have a Word document that has VB code behind it. It started out where a person could type in a part number and press a button, it would read the part number and mail merge the information from a SQL database along with our companies logo. The part information would be printed to all 30 cells in the table.
I had to create a second copy of this to allow multiple part numbers to be entered and each part number would be printed once. If an employee types 3 part numbers, I want to clear the company logo from the blank cells. I have the part numer also barcoded, so on the cells I want cleared there is also ** barcoded. I know I can do a find on ** to find the first cell to clear, but I am unsure about how to loop until thru the end of the table.
Any help would be greatly appreciated.
Thanks in advance,
DM
I had to create a second copy of this to allow multiple part numbers to be entered and each part number would be printed once. If an employee types 3 part numbers, I want to clear the company logo from the blank cells. I have the part numer also barcoded, so on the cells I want cleared there is also ** barcoded. I know I can do a find on ** to find the first cell to clear, but I am unsure about how to loop until thru the end of the table.
Any help would be greatly appreciated.
Thanks in advance,
DM
