قالب وردپرس درنا توس
Home / Tips and Tricks / How to create mail labels in Word from an Excel list

How to create mail labels in Word from an Excel list



  word logo

You may use Microsoft Excel to carefully organize an email list. But when you are ready to print email markers, you must use mailfusion to create them in Word from your Excel list. How to use.

Step one: Prepare your mailing list

If you have already created an email list in Excel, you can surely skip this test. If you have not yet created the list, we still recommend that you use Excel because it is better to organize and keep data than to use a Word table even though Excel lacks the mailing address.

The first thing you need to do Create a column header or the data that goes in each column. Place the headings in the first row of each column.

Which headings you include will depend on what information you plan to use in the mailing labels. Titles are always nice, but it is important that you know which title a person goes before you create the labels. If your list is for companies and not individuals, you can also release the title "First Name" and "Last Name" and just go with "Company Name" instead. To properly illustrate the steps, we go with a personal address list in this example. Our list will contain the following headings:

  • First Name
  • Last Name
  • Street Address
  • City
  • State
  • Postcode

This is the standard information you find on mailing labels. You can also insert images in the mailing label if you want, but this step comes later in Word.

RELATED: Creating and printing labels in Word

When you are finished creating the headlines, continue and enter data. When done, the list should look like this:

 Mailing List in Excel

Continue saving your list and let's switch to Microsoft Word.

Step two: Create labels in Word

Open a blank Word document. Then go to the "Mailings" tab and select "Start Mail Merge."

 Starting Mail Merge

In the drop-down menu that appears, select "Labels".

 Select labels from the menu

The "Label Options" window appears. Here you can choose the brand name and product number. When finished, click "OK".

 Label Options

Your label space is now displayed in Word.

 Label printing

Note! If your label outlines are not displayed, go to Design> Borders and select "View Gridlines."

Step Three: Connect Your Worksheet to Word Labels

Before you can transfer data from Excel to your labels in Word, you need to connect the two. Back to the "Mailings" tab in the Word document, select the "Select recipient" option.

 select recipient "width =" 216 "height =" 157 "src =" / pagespeed_static / 1.JiBnMqyl6S.gif "onload =" pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "onerror =" this.onerror = null; pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this);

A drop-down menu will appear. Select "Use an existing list."

 Use an existing list "width =" 233 "height =" 76 "src =" / pagespeed_static / 1.JiBnMqyl6S.gif "onload =" pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon this); "onerror =" this.onerror = null; pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this);

Windows File Explorer will be displayed. Use it to locate and select your address list file. With the selected file, click "Open".

 find address list "width =" 645 "height =" 123 "src =" / pagespeed_static / 1.JiBnMqyl6S.gif "onload =" pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "onerror =" this.onerror = null; pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this);

The "Select Table" window appears. If you have multiple sheets in your workbook, they appear here. Select the one that contains your list. Make sure that "First row of data contains column headers" is displayed if it is not already, and then click "OK".

 Select table "width =" 506 "height =" 243 "src =" / pagespeed_static /1.JiBnMqyl6S.gif "onload =" pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "onerror =" this.onerror = null; pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this);

Your labels are now linked to your worksheet.

Step Four: Add Mail Field Fields to Labels

Now is the time to add your letter field fields to Word tags. Select the first label, switch to the "Mailings" tab, and then click "Address Block".

 adressblock "width =" 438 "height =" 160 "src =" / pagespeed_static / 1.JiBnMqyl6S. gif "onload =" pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "onerror =" this.onerror = null; pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this);

In the "Insert Address Block" window click on the "Match Fields" button.

 Match field "width =" 366 "height =" 182 "src =" / sidorpeed_static / 1.JiBnMqyl6S.gif "onload =" pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon; "onerror =" this.onerror = null; pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this);

The "Match Field" window appears. Make sure each setting matches the column in the workbook in the Required for Address Block group. For example, "First Name" should match with "First Name" and so on.

 Match the corresponding field "width =" 335 "height =" 462 "src =" / pagespeed_static / 1.JiBnMqyl6S.gif "onload =" pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "onerror =" this.onerror = null; pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this);

Back in the "Insert Address Block" window, check out the preview to make sure everything looks good and then click "OK".

 Preview label "width =" 351 "height =" 366 "src =" / pagespeed_static / 1.JiBnMqyl6S.gif "onload =" pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "onerror =" this.onerror = null; pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this);

<> is now displayed in your first label.

 Address block in the first label

Return to the "Mailings" tab and then click "Update labels."

 update labels "width =" 439 "height =" 123 "src =" / pagespeed_static / 1.JiBnMqyl6S.gif "onload =" pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "onerror =" this.onerror = zero; pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this);

Once selected, <> should appear in each label.

 Address blocks in each label

Now you are ready to perform mail fusion.

] Step Five: Perform Mail Merge

Now to see the magic happen. On the "Mailings" tab, click "Finish and merge."

 exit and merge "width =" 277 "height =" 127 "src =" / pagespeed_static / 1.JiBnMqyl6S.gif "onload =" sidespeed .lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "onerror =" this.onerror = null; pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this);

Select "Edit individual documents" from the drop-down menu that appears. 19659005]  Edit individual documents "width =" 204 "height =" 75 "src =" / pagespeed_static / 1.JiBnMqyl6S.gif "onload =" sidespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "onerror =" this.onerror = null; pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this);

The "Merge to new document" window appears. Select "All" and then click "OK".

 merge into new document "width =" 254 "height =" 170 "src =" / pagespeed_static / 1.JiBnMqyl6S.gif "onload =" pagespeed.lazyLoadImages .loadIfVisibleAndMaybeBeacon (this); "onerror =" this.onerror = null; pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this);

Your list from Excel will now be merged into the labels in Word.

 Completed merging "width =" 514 "height =" 301 "src =" / pagespeed_static / 1.JiBnMqyl6S.gif "onload =" sidespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "onerror =" this.onerror = null; siding. lazyLoadImages.loadIfVisibleAndMaybeBeacon (this);

Everything left to do now is to print your labels and send out your mail!


Source link