Excel Mail Merge Format. But when the mail merge field is inserted it is displayed in us format. It will contain all the placeholder names which will become the personalized data such as first and last names addresses job titles etc.
Press shift f9 or right mouse click and select toggle field codes. Use a numeric switch in word the second way to cajole mail merge into displaying numbers from excel correctly is. Pick a field and press insert.
Click on the mailings tab and select start mail merge.
In the excel worksheet insert a column with a. The mail merge process consists of two parts. Select the mail merge field s you want to change. Under use an existing list choose browse and then open your formatted spreadsheet.
