How to Print Merge in Excel and Word

Table of contents:

2024 Author: Samantha Chapman | [email protected]. Last modified: 2023-12-17 09:13

Learning to use Mail Merge in Word can be tricky if you only rely on Microsoft's automated help. In this article we will tell you a much easier way starting from the implementation of creating an address book in Excel. going through the creation of the mail merge in Word and also explaining how to add more details and refine everything. This simple process will save you hours of battling with labels and, in the future, you won't have to write all your addresses by hand!

Note: This procedure works with Office 2003; with different versions the steps to follow may be different.

Steps

Mail Merge Address Labels Using Excel and Word Step 1

Step 1. Create an address book in Excel by entering names and addresses into an Excel sheet like so:

Mail Merge Address Labels Using Excel and Word Step 2

Step 2. In the first row you have to insert the labels, the "titles" of the columns

From the second line on, you can enter the actual data

Enter the names in column A.
Enter the surnames in column B.
Enter the street in column C.
Enter the city in column D.
Enter the status in column E.
Enter the post code in column F.
- # Save the file and remember where you saved it and under what name.
- # Close Excel.
Mail Merge Address Labels Using Excel and Word Step 3

Step 3. Open Word choose Tools> Letters> Print to Merge

If you don't see the panel on the right go to View> Panel. The panel on the right should appear

Mail Merge Address Labels Using Excel and Word Step 4

Step 4. Select the Labels item in the right panel

Mail Merge Address Labels Using Excel and Word Step 5

Step 5. Click Label Options and choose your label from the list

Click ok after choosing.

Mail Merge Address Labels Using Excel and Word Step 6

Step 6. Click on "Select recipients"

Mail Merge Address Labels Using Excel and Word Step 7

Step 7. Click on "Browse" and navigate through your folders until you find the file you created with Excel

Open the document and a dialog box will appear. All recipients should already be automatically selected, if by chance they are not, select them and then click "Ok".

Mail Merge Address Labels Using Excel and Word Step 8

Step 8. Click on "Arrange Labels"

Mail Merge Address Labels Using Excel and Word Step 9

Step 9. Click on "More" and select and enter the fields you want

Click on each single field (Name, Surname, Address, Postcode, City, State - for the address in Italian form) and then enter them one by one. Don't worry if they all appear on the same line for now, you'll fix them later. Once you have entered the fields you can separate them by adding spaces or by going to a new line. After entering all the fields click on "Ok". If you have forgotten to insert any fields positioned with the cursor where you want to insert the forgotten field, click on "Other", select and insert the new field and then click on close, once you have finished your entries and are satisfied that you have all the fields you need.

Mail Merge Address Labels Using Excel and Word Step 10

Step 10. Add spaces and wrap so the label looks right

Don't worry if the fields are checked and they turn gray and don't worry if the space you type turns gray, it will still be added in the label.

Mail Merge Address Labels Using Excel and Word Step 11

Step 11. Move the address to the right with paragraph indent

Usually this gives the label a better look but, of course, it depends on the size of your label and sometimes it might not fit!

When you are satisfied with how your label looks, click on "Update all labels". You should see that the fields are copied, formatted, in all the labels on your sheet

Mail Merge Address Labels Using Excel and Word Step 12

Step 12. Click on "Preview"

Mail Merge Address Labels Using Excel and Word Step 13

Step 13. If you are satisfied with the preview click on "Complete mail merge"

At this point you can edit the individual labels or the entire print by clicking on "Edit single labels". in the window that appears I suggest you to select "All" and then click on "Ok" so you will have access to all the labels spread over several pages.

Save before doing anything else

Mail Merge Address Labels Using Excel and Word Step 14

Step 14. You can also use online tools to create mail merge

The advantage is that these online tools are usually easier and faster to use.

3 Ways to Make Mushroom and Cream Sauce, Mushrooms and Tomato, Mushrooms and White Wine

Making a pasta sauce is a great way to use dehydrated mushrooms, bought fresh or picked yourself. This is a very versatile condiment as you can use almost any type of mushroom. In restaurants it is often found with cream or tomato, but at home you can also make it with only white wine.

How to Print on Avery Labels Using Microsoft Word on PC and Mac

This article explains how to print labels using adhesive labels manufactured by Avery and the Microsoft Word program on both Windows and Mac computers. Avery no longer distributes its own Word add-in which provided a wizard for creating and printing labels.

How to Use Mail Merge in Microsoft Word

You needed to send a letter or communication to multiple people, and because the address and header of the document differed from person to person, you spent hours creating each document individually. Fortunately, times have changed since then.

3 Ways to Use the Print Merge Process

Mail merge is a very common feature found in all office software. It allows you to send the same document to different recipients, personalizing it with the data of each. You can set up and perform this procedure to produce any type of document:

How to Merge Multiple Documents in Microsoft Word

This article explains how to merge multiple Microsoft Word documents into a single file. In addition to this it explains how to combine multiple versions of the same document to create a new Word file. Although merging multiple Word documents may seem complex at first, the steps to follow are very simple and the time required to perform is very limited.