To search this page press Ctrl+F; to search the site click on the Search menu

      
 

Mail merge FAQ

Sub-categories: [Beginners' Tips] [Formatting mail merge results] [Special Merges] [Miscellaneous]


  

Beginners' tips

How to create a Mail Merge

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

Link to Cindy Meister's FAQ site How to force Word to use the number format you want in a mail merge field

Link to Cindy Meister's FAQ site How to force Word to use the date format you want in a mail merge field

Link to Cindy Meister's FAQ site

How to get a mail merge to show the merge results in the same font in which the mergefield is formatted
  

Link to Cindy Meister's FAQ site

How to retain any special font formatting you may have in the Word Data Source

Link to Cindy Meister's FAQ site How to change the case of the mail merge result

Link to Cindy Meister's FAQ site

How to display database Yes/No information as Yes/No or as a checkbox in a mail merge field result

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

Link to Cindy Meister's FAQ site How to merge in a picture from a database

Link to Cindy Meister's FAQ site How to list multiple items using a single condition
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

Link to Cindy Meister's FAQ site How to Create an address book using a mail merge

Link to Cindy Meister's FAQ site How to suppress duplicate records during a mail merge

Link to Cindy Meister's FAQ site

How to Merge blocks of formatted text from separate source files during a mail merge

Link to Cindy Meister's FAQ site How to save each mail merged letter as a separate file

Link to Cindy Meister's FAQ site How to put barcodes in a mail merge form letter

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

Why is mail merge unavailable after using the Find Record feature in Word 97?

Link to Cindy Meister's FAQ site

How to show the complete list of available merge fields when the list is very long
  

Link to Cindy Meister's FAQ site

Mail merge field names in a Word document linked to an Excel Data Source have an underscore appended to them