Office 2013 Class #51: Fix Word 2013 Mail Merge Number Format Problem: Excel & Access Data Source

Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm
This video goes with the Highline Community College Busn 216 Computer Applications Class Access 2013.
Topics Covered In Video Word Mail Merge and Number Format Problem with Mail Merge.
1. What is Mail Merge: Connect Table with Fields to Word document to print or e-mail many letters. (00:45 min)
2. Word Letter Mail Merge w Excel Data (Number Format Problem & Field Code Fix) (02:43 min)
Number Rounded to 2 decimals:
Alt + F9 is toggle to show Field Code in Word
Code to add to end: \# 0.00
{MERGEFIELD Score_1} becomes {MERGEFIELD Score_1 \# 0.00}
Percentage:
Ctrl + F9 inserts MERGEFIELD code
{ MERGEFIELD Grade} becomes {={ MERGEFIELD Grade}*100 \# 0.00%}

3. Word E-mail Mail Merge w Excel Data (Number Format Problem TEXT function Fix) (13:40 min)
TEXT function converts a number to text given a certain Number Format
Number Rounded to 2 decimals use:
=TEXT(CellReference,"0.00")
Percentage:
=TEXT(CellReference,"0.00%")

4. Word E-Mail Mail Merge from Data In an Access Database (fix Number problem with Field code as in example 1 above) (18:26 min)
Word 2013 Mail Merge Number Problem. Fix Word 2013 Mail Merge Number Format Problem: Excel & Access Data Source.

Видео Office 2013 Class #51: Fix Word 2013 Mail Merge Number Format Problem: Excel & Access Data Source канала ExcelIsFun