Question about Seiko SMART LABEL PRINTER 440 USBW/2ROLLS SLP-2RL 2ROL - SLP440-KIT

Open Question

Mail merge from excel 2010 - Seiko SMART LABEL PRINTER 440 USBW/2ROLLS SLP-2RL 2ROL - SLP440-KIT

Posted by on

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How do I use Excel to pring labels with the Zebra LP2844?


I'm going to assume you can already print from the computer to the Zebra. I am also going to assume that since you have Excel, you also have Word. The first thing you need to do is layout the labels in Word. I cannot be more specific because I have no idea what size labels you are using.
Create and print labels

Next you need to merge the values from Excel into Word
Mail merge using an Excel spreadsheet

Here are some videos that might help
Mail merge Word

Feb 16, 2017 | Zebra Office Equipment & Supplies

1 Answer

HOW DO I CREATE A DATA BASE FOR FILE LABELS USING AVERY LABELS 6646? THANK YOU, BARB KOWALSKI


you can do it in excel
then mail merge excel file with
word https://support.office.com/en-us/article/Mail-merge-using-an-Excel-spreadsheet-858c7d7f-5cc0-4ba1-9a7b-0a948fa3d7d3

and use avery template in word
http://www.averyproducts.com.au/avery/en_au/Templates-%26-Software/Templates

Jan 27, 2017 | Avery Office Equipment & Supplies

1 Answer

When using Mail Merge, how can you make Word 2007 ignore any Blank cells in Excel 2007?


  • Open the Microsoft Excel 2007 spreadsheet file on your computer that contains the blank cells that you want to merge.

  • 2

    Use your mouse to select the adjacent blank cells that you want to merge together. The cells you want to merge should then be highlighted in blue.

  • 3

    Click on the "Home" tab and then click on the "Merge and Center" option from the "Alignment" group. The blank cells will all be merged and centered.

  • 4

    Click on the arrow next to the "Merge and Center" option and then click on the "Merge Across" option if you don't want the blank cells centered.

  • 5

    Select the merged cells and then click on the "Merge and Center" button again at any time to split the cells.

  • Mar 07, 2011 | Computers & Internet

    1 Answer

    How do you print envelopes?


    More information is required so I will only assume you are using Excel as a database. Excel is a spread sheet program used by accountants or for mathematical formulas and ledgers. Access is the Database program, however, Excel has functions which is faster to sort and work with address, phone number, zip codes. I will confess, I use Excel as Database because it is quick and easy. I do not know what version of Excel you are using so I will describe it from Office 2007. From Excel make sure you have headers above each column i.e. First Name in Cell A1 Last Name in Cell B1 Address in Cell C1 ect.

    Make sure your data is correct and case sensitive as you would like it. If you want zip+4 select the Colum and right click to format the cells using special and select Zip or Zip+4.
    It is easiest to use Microsoft Word for the next step rather than format the cells, add page breaks, and customize the print size.
    Save your document as an Excel document where you can find it to import it into Word.
    Open word and select Mailings then Start Mail Merge and Step by Step Mail Merge.
    Select Envelope and next. Select envelope options to change envelope size, font and print options.
    Click on Next Select recipients.
    Click on browse under select an existing list.
    Select the Excel file with your address information.
    From the Select Table check the First row of data contains column headers.
    Click on the OK buton.
    Arrange your envelope then Preview it and your good to go.
    If you have an older version of word selects Tools and click on Mail Merge.
    Select Get Data.
    Pull down Excel for document type.
    Select entire Spread Sheet.
    Layout your document and complete the merge.
    On old versions of word it may not recognize the Excel file. If this happens open the Excel file and save it as a Database File (.dbf) and it should work.
    I hope this helps since I did not have enough information from your question.

    Jul 15, 2009 | HP OfficeJet 6110 All-In-One InkJet...

    1 Answer

    Unable to complete merge process.


    Make sure you have closed the "data source" your excel file before trying to merge. This has been throwing different errors but not allowing the merge process to continue.

    Is your Excel data in various worksheets or in the same worksheet - And does your Excel source data contain headers in the first row. Once you have selected this from the range you will

    At what stage are you failing in the merge now?

    May 15, 2009 | Microsoft Office Professional 2007 Full...

    1 Answer

    I am having problems with a mail merge for tent card 5302 - can someone tell me how to merge an exisiting excel document into word?


    In Word 2003:
    Open the Tools Menu >> Letters and Mailings >> Mail Merge.
    Select Labels and click Next
    Click on Label Options and select your tent card and click OK and then Next
    Select Use Existing List and click Browse to find your Excel document. Click Next.
    Add in the fields you want on your cards to the first and then click Update All Labels.
    Finish Mail Merge Wizard.
    -- Word 2003 doesn't come with the 5302 label template. You'll need to download that from http://support.microsoft.com

    In Word 2007
    Select Mailings from the menu list at the top,
    Click on Start Mail Merge and select Labels
    Select Label vendor Avery US Letter
    Select your product number 5302 and click OK
    Click on Select Recipients from the top and select Use Existing List to browse to your Excel document
    Using the buttons on the top for Address Block/Greeting/etc add in the fields you want to the first label.
    Click on Update Labels
    Click on Finish and Merge

    Apr 28, 2009 | Computers & Internet

    1 Answer

    Mail Merge


    I assume XL means, Excel...what version are you using of office?

    Mar 19, 2008 | Computers & Internet

    Not finding what you are looking for?
    Seiko SMART LABEL PRINTER 440 USBW/2ROLLS SLP-2RL 2ROL - SLP440-KIT Logo

    Related Topics:

    83 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Seiko Office Equipment & Supplies Experts

    kakima

    Level 3 Expert

    102366 Answers

    yadayada
    yadayada

    Level 3 Expert

    76848 Answers

    Scott Kalvinek

    Level 2 Expert

    55 Answers

    Are you a Seiko Office Equipment and Supply Expert? Answer questions, earn points and help others

    Answer questions

    Manuals & User Guides

    Loading...