MS Word – Create a batch of letters based on a list using MS Excel or MS Access data (mail merge)

This will show you how to create a batch of letters (also known as a mail merge) based on a list of people from MS Excel or MS Access. You can also use other data sources such as MS SQL Server, MS Outlook, or even .csv or .txt files for a mail merge.

PREFIX FORMULAS

MS Excel: =IF(F3=”m”,”Mr. “, IF(F3=”f”,”Ms. “, IF(F3=”nb”,”Mx. “,”Mr./Ms./Mx.”)))

MS Access: prefix: IIf([gender]=”m”,”Mr. “,IIf([gender]=”f”,”Ms. “,IIf([gender]=”nb”,”Mx. “,”Mr./Ms./Mx.”)))

Note: You can change the formula above to your needs. For example, if you have “DK” for “Don’t know” you could change “nb” to “dk” and “.Mx” to “Don’t know”.