Excel Mail Merge Format. Formatting currency and number properly during mail merge in word. Press shift f9 or right mouse click and select toggle field codes.
All data to be merged is present in the first sheet of your spreadsheet. The mail merge process consists of two parts. In the excel worksheet insert a column with a.
For example to address.
Mergefield currency 0 00 note the 0 00 in the field is referred to as a numeric picture switch other possibilities include. In the mail merge pane under select recipients choose use an existing list. The template file the document you ll be sending out to your recipients. The mail merge fields will then look like the image below.
