fozzieqbear wrote:Our bishop is trying to send out a letter to the inactive members of our ward. I have been trying to figure out how to do a merge from the names in MLS with a letter in Microsoft Word. I have tried using the export function of MLS but the names go into the Excel csv document as "Last, First". That works well for address labels but not for addressing a label and I can't find a way of making first and last names 2 different fields.
I do that by using the LDSql database
, which imports the MLS export files and does some value-added processing. Among those features is that the database parses names into several forms suitable for mail-merge. For example:
John & Jane Doe (for address labels)
Brother and Sister Doe (for internal mail-merge within letters)
Once I have the LDSql database loaded, there a variety of ways to use those data elements in a mail-merge. It could simply be exported from a generic database tool in Firefox as CSV files, or an ODBC driver could be set up to connect directly to OpenOffice.