Below is a list of the most common customer questions. If you can’t find an answer to your question, please don’t hesitate to reach out to us.
Can you type merge fields into the main document?
Add or customize merge fields in the main document. City data field. Merge data from the data source in the main document to create a new, merged document. Merged document: This is the resulting document that you receive when you merge your mail-merge main document with your address list.
What types of documents can you create using mail merge?
Mail merge. Mail merge consists in combining mail and letters and pre-addressed envelopes or mailing labels for mass mailings from a form letter. Microsoft Word can insert content from a database, spreadsheet, or table into Word documents.
What is a merge field in Word?
Merge fields in Word for Windows. Merge fields are used to present the information correctly in the documents (such as contracts and invoices) that you export from System One.
How do you highlight merge fields in Word?
To highlight merge fields See To write a letter and insert a merge field to write a letter and insert merge fields. Click Mailings > Highlight Merge Fields. The merge fields are highlighted, so you can easily see where the records are inserted.
How do you convert a merge field to currency?
To format a numeric merge field, use the \\# switches. For example, to display a currency field as “$125.23", the merge field should be defined as {SEDGEFIELD myObject. myField \\# $#,##0.00}. To format a date merge field, use the \\@ switches.
How do you do a dollar amount in a mail merge?
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.
How do you format currency in a mail merge?
To format a numeric merge field, use the \\# switches. For example, to display a currency field as “$125.23", the merge field should be defined as {SEDGEFIELD myObject. myField \\# $#,##0.00}. To format a date merge field, use the \\@ switches.
How do I show percentage in mail merge?
To get it to display it as a percentage, we need to tell Word to multiply that value by 100. To do this, first we need to highlight the merge field. Highlight SEDGEFIELD and the name of the field, as shown: Once you've done that, press CTRL-F9 to embed this merge field into another field.
How do I change the font of a merge field in Word?
Open the merge document through the parameter file (not the finished product document).
Highlight all the merge fields at once.
Select Styles and Formatting from the Format menu. A window appears showing the current format.
Select the 'Normal' formatting to each of the merge fields.
Re-run the merge.
How do I remove a merge field in Word?
If you want to remove all fields, press Ctrl-A and the press Ctrl-6 (at the top of the keyboard). If you have fields in your headers/footers you need to go into those. Here is a macro that will unlink all merge fields in a document including headers/footers.
How do I format a merge field in Word to currency?
To format a numeric merge field, use the \\# switches. For example, to display a currency field as “$125.23", the merge field should be defined as {SEDGEFIELD myObject. myField \\# $#,##0.00}. To format a date merge field, use the \\@ switches.
How do I create a merge field in Word?
Click or tap where you want the merge field.
Choose the down-arrow under Insert Merge Field, and select a field.
If you don't see your field name in the list, choose Insert Merge Field.
Choose Database Fields to see the list of fields that are in your data source.
Choose Insert.
How do you do a mail merge for currency?
Suggested clip
How to Apply Currency Format to a Mail Merge Field — YouTubeYouTubeStart of suggested clipEnd of suggested clip
How to Apply Currency Format to a Mail Merge Field — YouTube