How to Create a Mail Merge From Excel to Word

By -

First, create a table in Excel with two columns: the first for names and the second for addresses. Close Excel and open the invitation format we created earlier in Microsoft Word.

Next, go to the Mailings menu, select Select Recipients, and then select Use an Existing List. A new window will appear. Locate the Excel file we created earlier.

Next, click the Excel file and click Open. A new window will appear. Select the sheet containing the table, then click OK. To display the Excel data in the Word file, first place your cursor where you want it to appear, for example, in the names section.

Select Insert Merge Field, then select Name. The name column heading will appear where you placed the cursor. Next, place your cursor in the addresses section, then return to Insert Merge Field, and select Address.

To display the list of names and addresses, simply click Preview Results. The column names will change to the list of names and addresses in the Excel file.

To change the name and address, simply click the right arrow next to Preview Results.

That's How to Create a Mail Merge From Excel to Word. I hope this tutorial is helpful. Also, check out the video tutorial I've prepared below. Good luck!


Comments

Post a Comment

Popular posts from this blog

How to Show Vertical and Horizontal Ruler in Word

By -
Image
A ruler or ruler is a very important part of a Microsoft Word worksheet, with a ruler or ruler, we can determine margins, numbering, and so on.  Well, sometimes suddenly or someone deliberately removes the ruler on the Microsoft Word worksheet that we have. There are 2 ways to display the vertical and horizontal rulers in Word, the first way is: Open a Microsoft Office Word document Open "View" menu Put a check mark on the "Ruler" Automatically, horizontal and vertical ruler will appear. The second way to show vertical and horizontal rulers in Word is: Open a Microsoft Office Word document Click the ruler icon above the vertical scroll bar Automatically, horizontal and vertical ruler will appear. Thank you and good luck... More Tutorials: How to Delete Text Box in Word How to Print on Microsoft Word 2007 How to Insert Portrait and Landscape in Same Word Document How to Convert Word 2010 to PDF How to Convert a Word 2007 Document to PDF More Tutorials: How to Move Wo...
Read more

How to make vertical text in Word table

By -
Image
There are times when we create a table in Word, the column titles or contents of the columns are very long so it is very difficult to adjust the width of the table so that it fits the width of the page. One way to make the table fit the width of the paper even though the table column headings are long is to make the writing vertical or extending from top to bottom. To make vertical writing in a Word table, it is very easy, friends, please read this tutorial until the end. First of all, prepare a table whose writing we will make vertical. Then select or select all the columns whose writing you want to change. After that, go to the Layout menu in Table Tools, then click Text Direction. Click Text Direction until the writing changes to vertical, there are two forms of vertical writing. Vertical writing that can be read from top to bottom and vertical writing that can be read from bottom to top, choose according to your wishes. After we change the shape of the writing to vertical, friends,...
Read more

How to Create and Set Quarto Paper Sizes in Word

By -
Image
Maybe some friends print using quarto paper and are confused about setting the quarto paper size in Word because the quarto paper is not listed in the paper size setting. In Word, quarto paper doesn't exist, but this paper size is listed under another name, but the size is the same. The size of quarto paper in word is the same as the size of "Letter" paper with a size of 21.5 cm x 27.9 cm. So if friends want to arrange quarto paper in Microsoft Word, just choose Letter type because Letter size is the same as Quarto. More Tutorials: How to Make Big Curly Brackets in Word How to Delete Page Number in Specific Page How to Set Password for Word Document 2007 How to Divide Into 4 Microsoft Word How to Remove Red Underline in Word
Read more