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-2668402%22%20slang%3D%22en-US%22%3ERe%3A%20AUTO%20PRINT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2668402%22%20slang%3D%22en-US%22%3EHI%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F93699%22%20target%3D%22_blank%22%3E%40Rajesh-S%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20you%20maybe%20have%20a%20look%20at%20this%3CBR%20%2F%3Eand%20maybe%20have%20any%20idea%20how%20to%20do%20it%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2672511%22%20slang%3D%22en-US%22%3ERe%3A%20AUTO%20PRINT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2672511%22%20slang%3D%22en-US%22%3E%3CP%3EAfter%20I've%20examined%20the%20attached%20file%20the%20Macros%20you%20are%20using%20are%20copying%20cell%20value%20from%20column%20F%20and%20pasting%20in%20F12%20then%20printing%20entire%20sheet%20rather%20than%20the%20SLIP%2C%2C%20I%20guess%20the%20SLIP%20is%20in%20the%20right%20most%20part%20having%20SKU%20and%20others%2C%2C%2C%20but%20is%20ONLY%20ONE%2C%2C%2C%20So%20my%20questions%20is%2C%2C%2C%3CBR%20%2F%3E1.%20How%20far%20I'm%20correct.%3CBR%20%2F%3E2.%20If%20I'm%20not%20wrong%20then%20actually%20you%20want%20to%20print%20variable%20number%20of%20copy%20of%20the%20SLIP!%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20yes%20please%20confirm%20then%20I'll%20show%20you%20how%20to%20do%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2686460%22%20slang%3D%22en-US%22%3ERe%3A%20AUTO%20PRINT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2686460%22%20slang%3D%22en-US%22%3Ehi%3CBR%20%2F%3Eyes%20after%20i%20copy%20the%20slp%20from%20F14%20to%20F12%20then%20the%3CBR%20%2F%3Ethen%20its%20pulls%20it%20to%20S19%20and%20fills%20all%20the%20areas%20there%20then%20printing%20that%20label%20templet%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2686478%22%20slang%3D%22en-US%22%3ERe%3A%20AUTO%20PRINT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2686478%22%20slang%3D%22en-US%22%3Emy%20biggest%20problem%20is%20that%20we%20get%20different%20amount%20of%20slp%20every%20time%3CBR%20%2F%3Ei%20would%20like%20to%20get%20rid%20of%20all%20the%20buttons%20print1%20print2%20print3%20....%3CBR%20%2F%3Eand%20just%20have%20one%20button%20print%20and%20its%20automatically%20detect%20how%20many%20is%20there%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2697560%22%20slang%3D%22en-US%22%3ERe%3A%20AUTO%20PRINT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2697560%22%20slang%3D%22en-US%22%3Ebeikme%20%2C%2C%2C%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThrough%20my%20last%20post%20I've%20already%20written%20to%20you%20about%20the%20possibility%2C%2C%2C%3CBR%20%2F%3E%3CBR%20%2F%3Eif%20you%20want%20to%20print%20variable%20nu%20of%20copy%20of%20the%20slip%20then%20I%20can%20suggest%20a%20macro.%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20confirm.%3CBR%20%2F%3E%3CBR%20%2F%3ERajesh%20Sinha.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2719397%22%20slang%3D%22en-US%22%3ERe%3A%20AUTO%20PRINT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2719397%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F93699%22%20target%3D%22_blank%22%3E%40Rajesh-S%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20attached%20a%20file%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20get%20from%201-150%20different%20slp's%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20i%20would%20need%20something%20that%20wold%20recognized%20how%20many%20slps%20are%26nbsp%3B%20and%20print%20that%20many%20times%20It%20would%20only%20print%20from%20P11-U27%20as%20thats%20the%20print%20area%26nbsp%3B%3CBR%20%2F%3Eand%20i%20would%20have%20some%20formulas%20to%20pull%20the%20rest%20of%20the%20info%20in%20there%20sa%20code%2Cjrs%20...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2720000%22%20slang%3D%22en-US%22%3ERe%3A%20AUTO%20PRINT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2720000%22%20slang%3D%22en-US%22%3ECan%20you%20explain%20why%20you've%20not%20investigated%20using%20Microsoft%20Word's%20MailMerge%20capability%2C%20using%20your%20Excel%20database%20as%20a%20source.%20It's%20practically%20tailor%20made%20to%20do%20what%20you%20want%20to%20do%2C%20and%20frankly%20gives%20a%20lot%20more%20flexibility%20in%20the%20layout%20of%20the%20final%20print....you%20could%20be%20printing%20those%20on%20pre-cut%20labels%2C%20the%20whole%20bit.%20As%20I%20said%20back%20at%20the%20start%2C%20you're%20re-inventing%20a%20wheel%20that's%20already%20been%20created%2C%20tested%2C%20proven%20effective....and%20having%20difficulty%20in%20the%20process.%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 

 

13 Replies
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.
HI @Rajesh-S

Can you maybe have a look at this
and maybe have any idea how to do it

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.

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

@Rajesh-S 

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

 

Can you explain why you've not investigated using Microsoft Word's MailMerge capability, using your Excel database as a source. It's practically tailor made to do what you want to do, and frankly gives a lot more flexibility in the layout of the final print....you could be printing those on pre-cut labels, the whole bit. As I said back at the start, you're re-inventing a wheel that's already been created, tested, proven effective....and having difficulty in the process.
Okay ,,, give me some time,, by tomorrow I'll post the solution ☺
Hi
The reason is that we have to use excel and I'm more comfortable using it
Thank You
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!!
Mail Merge USES Excel. And I question how comfortable you are, given that it hasn't worked yet.... Are you required to use Excel for the whole process, or just to use it? So I will repeat the question, why don't you at least investigate MailMerge through Word, USING Excel as the source? -- it works well and far more easily than your experience to date with Excel by itself. Excel is great, but there are some tasks where the two together are even better.

But that's the last time I'll suggest it, so you needn't even answer.