AUTO PRINT

%3CLINGO-SUB%20id%3D%22lingo-sub-2224953%22%20slang%3D%22en-US%22%3EAUTO%20PRINT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2224953%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20this%20issue%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20how%20to%20do%20some%20code%20for%20it%20but%20would%20like%20someone%20to%20maybe%20help%20whit%20it%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20print%2010-120%20label%20at%20once%26nbsp%3B%20but%20each%20time%20its%20different%20quantity%3C%2FP%3E%3CP%3EI%20have%20made%20some%20vba%20for%20it%20to%20print%20certain%20amount%20of%20labels%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20would%20like%20to%20just%20pas%20it%20in%20and%20the%20vba%20auto%20detect%20how%20many%20is%20there%20and%20print%20out%26nbsp%3B%20that%20amount%3C%2FP%3E%3CP%3E%26nbsp%3BI%20have%20attached%20a%20file%26nbsp%3B%3CBR%20%2F%3Eif%20someone%20could%20help%20i%20would%20appreciate%20it%26nbsp%3B%3CBR%20%2F%3EThank%20You%20in%20advance%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2224953%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2224975%22%20slang%3D%22en-US%22%3ERe%3A%20AUTO%20PRINT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2224975%22%20slang%3D%22en-US%22%3EI%20can't%20help%20with%20VBA.%3CBR%20%2F%3EI%20do%20wonder%20why%20you're%20not%20using%20Excel%20as%20the%20data%20source%20and%20Word's%20MailMerge%20as%20the%20way%20to%20print.%20That%20whole%20process%20is%20designed%20to%20print%20the%20number%20of%20labels%20that%20are%20there%20to%20be%20printed.%20You're%20re-inventing%20the%20wheel%20to%20do%20it%20some%20other%20way.%3C%2FLINGO-BODY%3E
Contributor

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 

 

1 Reply
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.