Share via

How can I convert an Excel file of address to mailing label?

Anonymous
2024-04-19T12:43:13+00:00

I have a wedding list of names and addresses in Excel and would like to generate mailing labels from it. Is there a simple way to do this using Excel & Word?

Thanks,

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-04-19T12:49:47+00:00

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2024-04-19T13:38:14+00:00

    Hello Gary,

    Thank you for reaching out to the Microsoft Community. My name is Marisol and I'm happy to help.

    Based on your description, you are trying to generate mailing labels using yout wedding lists of names and addresses.

    If your data source is an existing Excel spreadsheet, then you just need to prepare the data for a mail merge. But if your data source is a tab delimited (.txt) or a comma-separated value (.csv) file, you first need to import the data into Excel, and then prepare it for a mail merge.

    To do this, please follow these steps:

    Step 1: Set up your data source in Excel

    If you're using an Excel spreadsheet as your data source for a mail merge in Word, skip this step. If the data source is a .txt or a .csv file, use the Text Import Wizard to set up your data in Excel.

    After you successfully import a .txt or .csv file, go to Step 2.

    If you're using Excel for Microsoft 365

    1. Open Excel.
    2. Go to Data > From Text/CSV.
    3. Choose the .txt or .csv file you want, and then select Import.
    4. In the preview window, select Transform Data.
    5. Select the ZIP, Postal Code, or other column to format.
    6. Go to Transform > Data Type: and select Text.
    7. Select Replace current.
    8. Repeat steps 5 - 7 as needed.
    9. Select Close & Load.
    10. Go to File > Save as and save as with a different name.

    Step 2: Prepare your data source

    1. Choose the column that contains the ZIP Codes, postal codes, or other data to be formatted.
    2. Go to Home, and in the Number group, select the Number Format box down arrow, and then choose an option in the list (such as Text).

    Make sure you add the appropriate symbol before or after a merge field. To see full instruction with screenshot and examples, kindly please check this link: https://support.microsoft.com/office/2d802b6b-a3a3-43e5-bb76-2cac7c68673e

    Thank you. Please let me know if you need more assistance.

    Give back to the Community, Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

    Regards,

    Marisol D.

    Was this answer helpful?

    0 comments