Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Can you print mailing labels in microsoft access?

I have a bunch of addresses and I need to put them on labels to be mailed out, it is a lot to do one at a time and I was wondering if I could print the labels in either access or excel.

5 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    yes.

    These programs were made for this. I would go about my own way in Access, doing it the hard way, measuing the lables and creating reports that work with the lables and hit print and off I go.

    If you are not familar with Access, you would most likly have more success in Excel.

    From EXECL help files:

    Print labels by using Excel data in a Word mail merge

    By creating a mail merge in Word, and then linking to a list in Excel, you can turn worksheet data such as the addresses of your customers into printable mailing labels.

    In Microsoft Excel, set up the data to use in the mail merge.

    How?

    Make sure the data is in list (list: A series of rows that contains related data or a series of rows that you designate to function as a datasheet by using the Create List command.) format: each column has a label in the first row and contains similar facts, and there are no blank rows or columns within the list. You'll use the column labels to specify what data goes where in the mail merge.

    Make sure the column labels clearly identify the type of data in the column; this helps you select the right data as you construct the mail merge. For example, labels such as First Name, Last Name, Address, and City are better than Column 1, Column 2, Column 3, and Column 4.

    Make sure you have a separate column for each element that you want to include in the mail merge. For example, if you're creating form letters and want to use each recipient's first name in the body of the letter, make sure you have a column that contains first names, rather than a single column with both first and last names. If you want to refer to each recipient by title and last name, such as Mr. Smith, you can use a single column containing both titles and last names, or use one column for title and another for last name.

    To make the list easy to find when you select it for the mail merge, give it a name (name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.):

    How?

    Select the entire list.

    On the Insert menu, point to Name, and then click Define.

    Type a name for the list.

    Click Add, and then click Close.

    Save and close the workbook that contains the data.

    Switch to Microsoft Word.

    On the Tools menu, point to Letters and Mailings, and then click Mail Merge Wizard.

    In the first two steps of the Mail Merge Wizard, select the document type and start the document. If you're creating mailing labels, click Labels in Step 1, and then click Label options in Step 2 to select the size and type of labels to print.

    For more information about these steps, see Word Help.

    In the third step, under Select recipients, click Use an existing list, and then click Browse.

    In the Look in list, click the folder in which you saved the workbook with your data, click the workbook, and then click Open.

    In the Select Table dialog box, locate and click your list. Make sure the First row of data contains column headers check box is selected, and then click OK.

    In the Mail Merge Recipients dialog box, click any column labels in your data that correspond to the Word identifiers on the left. This step makes inserting your data in the form documents easier. For more information about matching fields, see Word Help.

    If you want to include only selected recipients in the mail merge, click Edit recipient list and select the recipients you want.

    Use the rest of the wizard steps to write, add recipient information, preview, personalize, save, and print or e-mail your documents. For information about these steps, see Word Help.

    Notes

    While Word has your workbook open to create the mail merge, you can't open the workbook in Excel. If you need to see the data and its column labels, go to Step 3 or 5 of the wizard and click Edit recipient list.

    You can continue to use mail merges with Excel data that you created in earlier versions of Word. To open and use these mail merges in Word 2002 or later, you'll need to install Microsoft Query. Query is no longer required to create new mail merges in Word 2002 or later.

  • dewald
    Lv 4
    5 years ago

    Open the Access database containing the cope with know-how you want to comprise on your labels. Choose the fairway Reports icon within the Objects pane of the Database window. Choose the fairway New icon from the toolbar placed on best of the Database window. Single-click on at the Label Wizard line within the New Report window that looks. Then decide on the desk or question that comprises your cope with know-how from the pull-down menu in that identical window. After making each choices, click on OK. When the Label Wizard opens, decide on the variety of labels you want to print and click on Next. Choose the font title, font measurement, font weight and textual content colour you might love to look in your labels and click on Next. Using the >> button, situation the fields you want to look at the label at the prototype label. When completed, click on Next to keep. Choose the database area you would like Access to kind situated upon. After you decide on the suitable area, click on Next. Choose a reputation on your record and click on Finish. Your label record will then look at the display. Preview the report back to be certain that it's proper. When convinced, load your printer with labels and print the record.

  • Anonymous
    1 decade ago

    Yes, just copy and paste em in Word and choose 'Lettersand stamps' under the file menu.

  • 1 decade ago

    if you want it to be automated kind of, use the microsoft word mail merge feature, if you get stuck talk to mr paperclip that microsoft programmed for you.

  • How do you think about the answers? You can sign in to vote the answer.
  • Anonymous
    1 decade ago

    No, but you can in Word.

Still have questions? Get your answers by asking now.