Exporting data for a mail merge - separating first and last names

Discussions around using and interfacing with the Church MLS program.
Tomicah
New Member
Posts: 1
Joined: Sun Oct 07, 2012 7:52 am

Exporting data for a mail merge - separating first and last names

Postby Tomicah » Sun Oct 07, 2012 8:03 am

We are trying to export data from MLS in order to complete a large mail merge for several different demographic groups within the ward. We haven't found a way to delink the last and first names in order to use them in a letter (e.g. right now, we can only export the data as "Doe, John" instead of as separate fields for "John" and "Doe"). Can someone please help us address this problem?

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

Postby aebrown » Sun Oct 07, 2012 1:03 pm

tomicah wrote:We are trying to export data from MLS in order to complete a large mail merge for several different demographic groups within the ward. We haven't found a way to delink the last and first names in order to use them in a letter (e.g. right now, we can only export the data as "Doe, John" instead of as separate fields for "John" and "Doe"). Can someone please help us address this problem?


When I need to do that, I export the data to a spreadsheet, then use the spreadsheet functions to separate the first and last names. If you need specific details on how to do that, I can give you the formulas.
Questions that can benefit the larger community should be asked in a public forum, not a private message.


Return to “MLS Support, Help, and Feedback”

Who is online

Users browsing this forum: No registered users and 1 guest