ok so this is getting pretty challenging but someone might be able to help me.
I have a spreadsheet with multiple columns.
Customer name and details, Client ID number, staff elocated to them ect.
Each day we get a long list of clients for the day and for each of these clients i need to print out a variable number of labels.
I have a label printer with two labels(stickers) side by side both together measuring w50mm x h20mm so each label would be w25mm x h20mm and the two would need to be printed together.
So what i want to do is have a macro that prints labels from various data on one row and have it print in a certain format and print as many labels as is recorded in one of the columns.
This will somehow need to set the page size at the 50 x 20mm through the macro?
Is any of this possible??
The printer is TLP 2844 and uses ELP2
Thanks
I have a spreadsheet with multiple columns.
Customer name and details, Client ID number, staff elocated to them ect.
Each day we get a long list of clients for the day and for each of these clients i need to print out a variable number of labels.
I have a label printer with two labels(stickers) side by side both together measuring w50mm x h20mm so each label would be w25mm x h20mm and the two would need to be printed together.
So what i want to do is have a macro that prints labels from various data on one row and have it print in a certain format and print as many labels as is recorded in one of the columns.
This will somehow need to set the page size at the 50 x 20mm through the macro?
Is any of this possible??
The printer is TLP 2844 and uses ELP2
Thanks
