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.
- Mail Merge On A Mac Excel To Word
- Mail Merge Word For Mac With Excel Converter Not Found Free
- Mail Merge For Mac From Excel To Word
In Word 97, here is what you do:
Mail Merge - Create an Excel Spreadsheet with Column headings, add data, and merge the data into a MS Word Document. Very easy and fun. Create a personal let. 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. For example, instead of displaying 1.0014, Mail Merge showed 1.0013. But let’s say that you can’t or don’t want to change your Excel spreadsheet. Well, there is something we can do in Word: 2. Use a “Numeric Switch” in Word. The second way to cajole Mail Merge into displaying numbers from Excel correctly is to modify the Word.
Mail Merge On A Mac Excel To Word
(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.
Return to ED303 Home Page.
Mail Merge Word For Mac With Excel Converter Not Found Free
This page was prepared by Dr. David M. Marcovitz.
Mail Merge For Mac From Excel To Word
Last Updated: July 31, 1998