Mail merge FAQ
Beginners' tips
Creating a Mail Merge Data Source
Making your mail merge “intelligent” by using IF fields
Turning Word into a pseudo-database by using Mail Merge Query Options
Formatting mail merge results
How to force Word to use the number format you want in a mail merge field [Lene Fredborg, 10-Jan-2020: Removed outdated link to http://homepage.swissonline.ch/cindymeister/]
How to force Word to use the date format you want in a mail merge field [Lene Fredborg, 10-Jan-2020: Removed outdated link to http://homepage.swissonline.ch/cindymeister/]
How to get a mail merge to show the merge results in the same font in which the mergefield is formatted [Lene Fredborg, 10-Jan-2020: Removed outdated link to http://homepage.swissonline.ch/cindymeister/]
How to retain any special font formatting you may have in the Word Data Source [Lene Fredborg, 10-Jan-2020: Removed outdated link to http://homepage.swissonline.ch/cindymeister/]
How to change the case of the mail merge result [Lene Fredborg, 10-Jan-2020: Removed outdated link to http://homepage.swissonline.ch/cindymeister/]
How to display database Yes/No information as Yes/No or as a checkbox in a mail merge field result [Lene Fredborg, 10-Jan-2020: Removed outdated link to http://homepage.swissonline.ch/cindymeister/]
Special merges
How to mail merge to email with attachments
How to do a mail merge to the printer using VBA, without displaying the Print dialog
Or in the case of Word 2002, how to do the opposite!
How to do an international mail merge, with barcodes, from the US
How to merge in a picture from a database [Lene Fredborg, 10-Jan-2020: Removed outdated link to http://homepage.swissonline.ch/cindymeister/]
How to list multiple items using a single condition [Lene Fredborg, 10-Jan-2020: Removed outdated link to http://homepage.swissonline.ch/cindymeister/]
Sometimes, you want to create a mail merge where you can list several items for one particular category, such as the invoices for each customer
How to Create an address book using a mail merge [Lene Fredborg, 10-Jan-2020: Removed outdated link to http://homepage.swissonline.ch/cindymeister/]
How to suppress duplicate records during a mail merge [Lene Fredborg, 10-Jan-2020: Removed outdated link to http://homepage.swissonline.ch/cindymeister/]
How to Merge blocks of formatted text from separate source files during a mail merge [Lene Fredborg, 10-Jan-2020: Removed outdated link to http://homepage.swissonline.ch/cindymeister/]
How to save each mail merged letter as a separate file [Lene Fredborg, 10-Jan-2020: Removed outdated link to http://homepage.swissonline.ch/cindymeister/]
How to put barcodes in a mail merge form letter [Lene Fredborg, 10-Jan-2020: Removed outdated link to http://homepage.swissonline.ch/cindymeister/]
Miscellaneous
I have a “Name” column which I want to split into “FirstName”, “LastName” – how can I do it?
How to convert addresses into a Mail Merge Data Source
Sequentially numbering multiple copies of single document using a mailmerge
How to show the complete list of available merge fields when the list is very long [Lene Fredborg, 10-Jan-2020: Removed outdated link to http://homepage.swissonline.ch/cindymeister/]
Mail merge field names in a Word document linked to an Excel Data Source have an underscore appended to them [Lene Fredborg, 10-Jan-2020: Removed outdated link to http://homepage.swissonline.ch/cindymeister/]