Loadreports675

Learn how to Mail Merge with Office 365, Office 2019, Office 2016, Office 2013, or Office 2010. Mail Merge allows you to send customized envelopes, letters. If you have Classic Menu for Word 2007/2010/2013/2016/2019 installed. Just take Microsoft Word 2010 for example, which is as well as in Word 2007/2013. With Classic Menu for Word installed, you can click Menus tab to get back the classic style interface. Click Menus tab; Move to Mailings menu; There is a Start Mail Merge option to choose. Sep 27, 2009 However, when using Mail Merge in Word 2008 and an Excel xlsx file as data source under OS X 10.6, the file converter will not recognize the file unless the extension.xlsx is actually appended to. If you use Microsoft Office 2016 with a Mac computer, you can easily import addresses or other data from an Excel spreadsheet or from your Apple Contacts.

Where is the Mail Merge in Microsoft Word 2007, 2010, 2013, 2016, 2019 and 365

We always use mail merge to set up a serious of letter that essentially the same but contain different elements. For example, when we send emails to hundreds of our clients, the contents are same but the addresses are different. At that time, we can use mail merge in Word to start the process.

Many users will have difficulties in finding the position of mail merge. Please don’t worry. This article helps pointing out the position of merging mails. Let’s take a look.

If you have Classic Menu for Word 2007/2010/2013/2016/2019 installed.

Just take Microsoft Word 2010 for example, which is as well as in Word 2007/2013. With Classic Menu for Word installed, you can click Menus tab to get back the classic style interface.

• Click Menus tab
• Move to Mailings menu
• There is a Start Mail Merge option to choose

If you have not Classic Menu for Word 2007/2010/2013/2016/2019 installed, you can …

Mail Merge Word For Mac With Excel Converter Not Found Windows 10

• Click Mailing tab
• Go to Start Mail Merge group
• Click the down arrow next to the Start Mail Merge

More Tips

What is Classic Menu for Office

The software Classic Menu for Office is designed for the people who are accustomed to the old interface of Microsoft Office 2003, XP (2002) and 2000. It brings back the classic menus and toolbars to Microsoft Office (includes Word) 2007, 2010, 2013, 2016, 2019 and 365. The classic view helps the people to smoothly upgrade to the latest version of Office, and work with Office 2007/2010/2013/2016 as if it were Office 2003 (and 2002, 2000).

Screen Shot of Classic Menu for Word

• All new features and commands of Office 2007, 2010, 2013, 2016, 2019 and 365 have been added to the menus and toolbars;
• Without any training or tutorials after upgrading, users can work with Office 2007/2010/2013/2016 immediately;
• Easy to find any command items you want to process;
• Easy to show or hide the classic menus, toolbars and ribbon tabs;
• Easy to install and use. Supports all languages. Free download!

You might find that you have difficulty formatting numbers properly when using Mail Merge in Microsoft Word. This can be a problem if you are calculating numbers in your source (especially when your source is an Excel spreadsheet or Access database). For example, you might have a simple gradebook that averages three grades to get a final grade. If a student has grades of 90, 95, and 99, his average will be 94.66666666666666666.... Excel or Access can easily be set to format the numbers to 1 or 2 decimal places, but that formatting will not necessarily show up in your mail merge document. You do not want to send home a mail merge letter to your student's parents congratulating them on their daughter's outstanding average of 94.66666666667 in your class. The letter would be much better if it congratulated them on their daughter's average of 94.7.

In Word 97, here is what you do:

Mail Merge Word For Mac With Excel Converter Not Found One

(1) Create the mail merge letter as you normally would, include the field for the final grade. Your merged field will look like this: «FinalGrade»

(2) Right click your mouse on the field and select the Toggle Field Codes option from the popup menu. Your merged field will now look like this: {MERGEFIELD FinalGrade }. This is the same thing as before; it is merely showing the information to you in a different way.

(3) Next, you need to insert a special code to tell Word 97 that you want to round this off to one decimal place. After the name of the field (FinalGrade) and before the bold close curly bracket, type the following: #0.0

(4) Your merged field now looks like this: {MERGEFIELD FinalGrade #0.0}. This will round your number to one decimal place, so in the above example the number will be 94.7. If you want to round to two decimal places, use #0.00 in your merge field. If you want the number to have a dollar sign before it (for anything that is money), use #$# in your merge field. If you want commas in your number, use ##,### in your merge field. If you want dollars, rounded to two decimal places with commas, use #$#,##0.00 in your merge field.

Mail Merge Word For Mac With Excel Converter Not Found Using

Return to ED303 Home Page.

This page was prepared by Dr. David M. Marcovitz.

Last Updated: July 31, 1998