Created barcodes in Excel to print labels

%3CLINGO-SUB%20id%3D%22lingo-sub-1506777%22%20slang%3D%22en-US%22%3ECreated%20barcodes%20in%20Excel%20to%20print%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1506777%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20created%20sequential%20barcodes%20in%20Excel%20and%20need%20to%20print%20them%20on%20an%20Avery%20label.%26nbsp%3B%20Every%20time%20I%20try%20to%20merge%2C%20I%20am%20only%20getting%20the%20formula%20to%20print%2C%20not%20the%20result%20of%20the%20formula%20(barcode).%26nbsp%3B%20It%20prints%20fine%20from%20excel.%26nbsp%3B%20It%20seems%20to%20not%20communicate%20between%20the%20two%20programs.%26nbsp%3B%20Is%20this%20possible%3F%26nbsp%3B%20Instead%20should%20I%20create%20labels%20in%20Word%20and%20merge%20from%20Excel%20to%20Word%20label%20format%3F%26nbsp%3B%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Label%20Excel%202020-07-07%20123850.png%22%20style%3D%22width%3A%20786px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F203914iFE986C83364F021D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Label%20Excel%202020-07-07%20123850.png%22%20alt%3D%22Label%20Excel%202020-07-07%20123850.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1506777%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1509717%22%20slang%3D%22en-US%22%3ERe%3A%20Created%20barcodes%20in%20Excel%20to%20print%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1509717%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F721410%22%20target%3D%22_blank%22%3E%40atrump%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20no%20experience%20with%20product%20barcodes%20%3CEM%3Eper%20se%3C%2FEM%3E%2C%20but%20I%20do%20use%20mail%20merge%20from%20Excel%20to%20Word%20for%20address%20labels%20and%20have%20the%20zip%20code%20bar%20codes%20print.%20I%20always%20do%20that%20by%20letting%20the%20Word%20feature%20process%20the%20zip%20code.%20I'd%20assume%20the%20same%20would%20work%20for%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

I have created sequential barcodes in Excel and need to print them on an Avery label.  Every time I try to merge, I am only getting the formula to print, not the result of the formula (barcode).  It prints fine from excel.  It seems to not communicate between the two programs.  Is this possible?  Instead should I create labels in Word and merge from Excel to Word label format?  Label Excel 2020-07-07 123850.png

1 Reply

@atrump 

 

I have no experience with product barcodes per se, but I do use mail merge from Excel to Word for address labels and have the zip code bar codes print. I always do that by letting the Word feature process the zip code. I'd assume the same would work for you.