Word – how to mail merge many records to individual documents
I use Microsoft Word's mail merge feature often. It works great for connecting into a database and spitting out all sorts of documents - but it's kind of clunky when…
Mail merge
Word – mail merge field changes format (font/size) when merged
Problem When running a mail merge in Microsoft Word some merge fields change format. For example, the font or size will change. Changing the styles applied to the field or…
SQL – How to insert new line/line break in string
If you're building a string using an SQL statement, you can split results with "new lines" using CHAR() to insert the ASCII line break character into your string. For example,…
How to remove mail merge data source from Word document
The following steps show how to remove the link between a Word document and a mail merge data source. When you open a Word document that has mail merge data…
Word 2010 – Calculations using mail merge fields
One of the little known features of Microsoft Word is the ability to do calculations based on mail merge fields. The process is as easy as creating an expression field…
Word 2010 – Automatically Format Currency Mail Merge Fields
When using Word 2010 to create mail merges you can customise fields to automatically format the text or numbers as required. In this example we will be customising a merge…