#Word 2013 mail merge from excel how to
#Word 2013 mail merge from excel full

Giving identical names to your Excel column will help Mail Merge to automatically match the fields and save you the trouble of mapping the columns manually. The screenshot below shows a list of the Address block fields used by Word.

#Word 2013 mail merge from excel full

For address fields, use the full words such as Address, City, State, Postal or Zip code, Country or Region.

Give clear and unambiguous names to your Excel columns such as First Name, Middle Name, Last name, etc.

Here are a few important things to check: This will make it easier for you to arrange, review and print your mailing labels in Word and save more time in the long run. Microsoft Word will be pulling out the information from your Excel columns and placing it into the corresponding merge fields in this way:Д«efore starting a mail merge, invest some time in setting up your Excel spreadsheet to ensure it is properly structured. Or, it can combine several entries, for example the В«AddressBlockВ» field. A merge field can correspond to one entry such as first name, last name, city, zip code, etc. In essence, when you mail merge labels or envelopes from Excel to Word, the column headers of your Excel sheet are transformed into mail merge fields in a Word document. The steps are essentially the same in Excel 2021, Excel 2019, Excel 2016, Excel 2010, and very similar in Excel 2007. Whatever intricate and intimidating the task may sound, it boils down to 7 basic steps.Д«elow, we'll take a closer look at each step using Microsoft 365 for Excel. If you've had a chance to read our Mail Merge tutorial, a larger part of the process will be familiar to you because making labels or envelopes from Excel is yet another variation of the Word Mail Merge feature.

Prepare Excel spreadsheet for mail merge.

Today let's see how you can leverage this feature to make and print labels from an Excel spreadsheet. Last week we started to look into the capabilities of Word Mail Merge.

#Word 2013 mail merge from excel how to

You will learn how to prepare your Excel address list, set up a Word document, make custom labels, print them and save for later use. DDE has now been disabled in modern Office as a security risk.The tutorial explains how to do a mail merge from an Excel spreadsheet for labels. There was an older вЂ Dynamic Data ExchangeвЂ system available for communication between Office apps. ItвЂ™s the easiest to use, just insert into the merge document and itвЂ™ll appear exactly the same as in Excel. вЂPercentageasTextвЂ™ locks you into a single format to display in Word. There may be cases where you use the same Excel data in different formats for the mail merge. Probably вЂPercentagex100вЂ™ is the better choice since it sends a number (not text) to Word that you can format in any way you wish. Д®ither вЂPercentagex100вЂ™ or вЂPercentageasTextвЂ™ will work in a Word mail merge.

PercentageasText: is the column B value converted to text (using the TEXT function) with percentage formatting applied.

Percentagex100: is the fraction from column B multiplied by 100. This is the usual way percentages are handled in Excel.ДЄctual Value: exposes the value in column B in the way Excel stores it, in other words as a fraction.

Percentage: Column B is the fraction (eg 0.12) displayed as a percentage. HereвЂ™s a sample worksheet that shows you two different ways to вЂmassageвЂ™ a percentage into a Word friendly form (the data is fictional): The most direct option is to add some columns in Excel with versions of the percentage figure that you can use in Excel. Remember to press Ctrl + F9 to make the field вЂ“ not the curly brackets on the keyboard. This lets you multiply the number coming from Excel by 100 before formatting. To do it embed the MERGEFIELD inside another Word field. You can change the decimal fraction (eg 0.738) toВ a percentage (73.8) in Word. Normally, a Word mail merge will import the raw number from Excel and let you format it in way weвЂ™ve described before.ДЄs usual, thereвЂ™s more than one solution to the problem: Formatting in Word For example 25% is stored in Excel as 0.25. How can you put percentages into a Word mail merge?ДЇollowing our article on importing Excel data into a Word mail merge, here are the options for using percentages.Д®xcel might show a percentage but the number stored is a fraction.