Forum Discussion
AUTO PRINT
Hi all
I have this issue
I know how to do some code for it but would like someone to maybe help whit it
I need to print 10-120 label at once but each time its different quantity
I have made some vba for it to print certain amount of labels
But would like to just pas it in and the vba auto detect how many is there and print out that amount
I have attached a file
if someone could help i would appreciate it
Thank You in advance
13 Replies
- beikme ,,,
Through my last post I've already written to you about the possibility,,,
if you want to print variable nu of copy of the slip then I can suggest a macro.
Please confirm.
Rajesh Sinha.Hi
I attached a file
I can get from 1-150 different slp's
so i would need something that wold recognized how many slps are and print that many times It would only print from P11-U27 as thats the print area
and i would have some formulas to pull the rest of the info in there sa code,jrs ...- My dear beikme still I'm highly confused that what exactly you are trying to print since there is no P11-U27 each button is printing the SKU code,,,, honesty I'm unable to realize the issue so that can't solve it,, feeling sorry for that!!
After I've examined the attached file the Macros you are using are copying cell value from column F and pasting in F12 then printing entire sheet rather than the SLIP,, I guess the SLIP is in the right most part having SKU and others,,, but is ONLY ONE,,, So my questions is,,,
1. How far I'm correct.
2. If I'm not wrong then actually you want to print variable number of copy of the SLIP!
If yes please confirm then I'll show you how to do this.- my biggest problem is that we get different amount of slp every time
i would like to get rid of all the buttons print1 print2 print3 ....
and just have one button print and its automatically detect how many is there - hi
yes after i copy the slp from F14 to F12 then the
then its pulls it to S19 and fills all the areas there then printing that label templet
- I can't help with VBA.
I do wonder why you're not using Excel as the data source and Word's MailMerge as the way to print. That whole process is designed to print the number of labels that are there to be printed. You're re-inventing the wheel to do it some other way.
