How To Use Comma In Mail Merge

How to use mail merge in word and excel to send letters walkthrough guide you can use the mail merge feature in word and excel to create and print personalized mass letters quickly.

How to use comma in mail merge. You might use them to clean up an address by suppressing unwanted spaces or adding commas at the right spot. If you want commas in your number use in your merge field. Even the simplest mail merge task can benefit from conditional statements. Or right click on the mail merge field and choose the toggle field code option. Column names in your spreadsheet match the field names you want to insert in your mail merge.

For example to address readers by their first name in your document you ll need separate columns for first and last names. Select the field such as amount as shown in this example. If you want the number to have a dollar sign before it for anything that is money use in your merge field. Here the mail merge template is a form letter in microsoft word. All data to be merged is present in the first sheet of your spreadsheet.

The number of number signs typed after the comma indicate the number of digits that should be forced to display 00 indicates that you want to include a decimal point to two places with each number. You should now see the actual field code for the field which should look something like mergefield amount. 6 click mailings start mail merge letters select recipients use existing list select the list you just made click ok 7 click insert merge field click date then ok 8 press enter to move to next line 9 click insert merge field click datetext then ok 10 click preview results jump through the 2 entries. If you want to round to two decimal places use 0 00 in your merge field. Indicates that you want commas to designate thousands.