Mail merge file

Got a question or comment about PowerChurch that doesn't belong anywhere else? Why not post it here!?

Moderators: Moderators, Tech Support

Post Reply
Otto
Posts: 22
Joined: Sat Feb 28, 2004 1:20 pm
Location: Holy Trinity Church

Mail merge file

Post by Otto »

In using the mail merge to MsWord I find it a problem that PC exports Mail merge in a limited way as "Salutation", "Mailing Name", "Address" and so on.
The problem is with "Mailing Name" it is exported as one block "Mr. John Doe"
and not very useful in a form letter. I would like to see this exported in 3 parts as "Title" "First Name" "Last Name" to mach the setup in word and be able to insert any one part in the letter as Dear John or Dear Mr. Doe instead of Dear Mr. John Doe. Has anyone been able to make a replacement file to fix something like this?
Running PC-Church 9 updated December.

Otto.

NeilZ
Posts: 10409
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Mail merge file

Post by NeilZ »

Otto wrote:In using the mail merge to MsWord I find it a problem that PC exports Mail merge in a limited way as "Salutation", "Mailing Name", "Address" and so on.
The problem is with "Mailing Name" it is exported as one block "Mr. John Doe"
and not very useful in a form letter. I would like to see this exported in 3 parts as "Title" "First Name" "Last Name" to mach the setup in word and be able to insert any one part in the letter as Dear John or Dear Mr. Doe instead of Dear Mr. John Doe. Has anyone been able to make a replacement file to fix something like this?
Running PC-Church 9 updated December.

Otto.
Are you selecting the mail merge from the Mailing List profiles, or the Personal Profiles

Personal profiles mail merge file is broken down in that manner. The mailing list mail merge file will use whatever you have listed in the Salutation, so if you have John & Mary in that block in the mailing list profile it will use that.

Hope this helps.
Neil Zampella

Using PC+ since 1999.

Otto
Posts: 22
Joined: Sat Feb 28, 2004 1:20 pm
Location: Holy Trinity Church

Mail Merge

Post by Otto »

Thanks Neil, I see it is that way in Personal Profile under Membership.
I am using Contributions---Create Mail Merge File---Selected Contributors---Selection Criteria and then set the Fund number to a Memorial Fund Number in order to send thank you letters to the people that donated to that Fund. It is simple doing it that way, but it uses the Mail format with the name as a block. If I use the Personal Profile under Membership I can't set a Fund number so it means printing the Fund list and then have to sit and find each name to Tag it, a long job.
It would be nice if the Contribution module could be set to use the Personal Profile mail setup, it is much more useful.
Otto.

Post Reply