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
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:
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."
In the drop-down menu that appears, select "Labels".
The "Label Options" window appears. Here you can choose the brand name and product number. When finished, click "OK".
Your label space is now displayed in Word.
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.
A drop-down menu will appear. Select "Use an existing list."
Windows File Explorer will be displayed. Use it to locate and select your address list file. With the selected file, click "Open".
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".
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".
In the "Insert Address Block" window click on the "Match Fields" button.
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.
Back in the "Insert Address Block" window, check out the preview to make sure everything looks good and then click "OK".
Return to the "Mailings" tab and then click "Update labels."
Once selected, <
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."
Select "Edit individual documents" from the drop-down menu that appears. 19659005]
The "Merge to new document" window appears. Select "All" and then click "OK".
Your list from Excel will now be merged into the labels in Word.
Everything left to do now is to print your labels and send out your mail!