Mail merge from LDS

Discussions around using and interfacing with the Church MLS program.
fozzieqbear-p40
New Member
Posts: 2
Joined: Mon Feb 22, 2010 11:18 am
Location: Gaffney, South Carolina

Mail merge from LDS

Postby fozzieqbear-p40 » Tue Feb 23, 2010 10:43 am

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.

Any ideas?

russellhltn
Community Administrator
Posts: 20781
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

Postby russellhltn » Tue Feb 23, 2010 10:52 am

If you use MLS's own Mailing Label function, it will print it as First Last.

If you're trying to do a mail merge into the letter, then I'd suggest using some Excel functions to parse the name field and reverse the order.
Have you searched the Wiki?
Try using a Google search by adding "site:tech.lds.org/wiki" to the search criteria.

User avatar
aebrown
Community Administrator
Posts: 14693
Joined: Tue Nov 27, 2007 8:48 pm
Location: Sandy, Utah

Postby aebrown » Tue Feb 23, 2010 11:13 am

RussellHltn wrote:If you're trying to do a mail merge into the letter, then I'd suggest using some Excel functions to parse the name field and reverse the order.


If anyone reading this is not very familiar with Excel, here are some formulas to extract the first and last names from a cell in "Last, First Middle" format:

  • Last: =LEFT(A1,FIND(",",A1)-1)
  • First & Middle: =MID(A1,FIND(",",A1)+2,99)
These assume that the full or preferred name is in cell A1. You can change that to whatever cell name is appropriate.

I would also note that if you have households with different mailing addresses than residential addresses, you might want to review the instructions in the wiki for Exporting Mailing Labels.

RossEvans
Senior Member
Posts: 1346
Joined: Wed Jun 11, 2008 8:52 pm
Location: Austin TX
Contact:

Postby RossEvans » Tue Feb 23, 2010 11:36 am

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.

Any ideas?


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.

fozzieqbear-p40
New Member
Posts: 2
Joined: Mon Feb 22, 2010 11:18 am
Location: Gaffney, South Carolina

Postby fozzieqbear-p40 » Wed Feb 24, 2010 7:16 am

Thank you for the responses. The Excel formulas worked perfectly in separating the fields.


Return to “MLS Support, Help, and Feedback”

Who is online

Users browsing this forum: No registered users and 2 guests