Skip navigation

Merging recipient and spouse's name

357 Views 4 Replies Latest reply: Dec 5, 2012 9:49 PM by ImaBowhunter RSS
ImaBowhunter Calculating status...
Currently Being Moderated
Dec 3, 2012 2:30 PM

I am creating a letter to send out to people and I will be merging addresses from a group in address book with the letter created in Pages (iWork '09). Everything  works fine when only sent to an individual, but many of the letters need to go to couples and the greeting needs to list both names. So I am trying to figure out how when sending to one person I get this:

 

Dear Christopher,

 

 

And when sending to a couple, I get this:

 

Dear Christopher and Brenda,

 

 

I am using the fields <first name> and <spouse> to draw from for the merge. Is there any way to conditionally add "and" to the heading when a second name is present, and also put the comma in the proper position depending on if one person or two are included?

 

Currently, if I leave a space for spouse but a spouse name isn't available, I get:

 

Dear Christopher ,

 

If I place both names in a document, I currently end up with:

 

Dear ChristopherBrenda,

 

 

I'm assuming there's a simple way to get this done. I just can't figure it out.

 

Thanks!

Mac mini, Mac OS X (10.7.5)
  • Jerrold Green1 Level 7 Level 7 (28,150 points)
    Currently Being Moderated
    Dec 4, 2012 12:30 AM (in response to ImaBowhunter)

    Hi Ima,

     

    It seems that Contacts in Mountain Lion has dropped the Spouse field. I don't recall ever using a Spouse field, but I assume that it was there since you're using it. I mention this becsuse I was going to look at what might be done to solve your question and was surprised not to find the spouse field on my system. No Custom field either.

     

    So, I think there might be some options. One would be to edit your Address Cards to move the spouse information into the First Name field so it would read Christopher and Brenda, before attempting the Mail Merge. I can understand why you might not like that. I used to do family cards that way all the time until it got to the point that so many of our friends had his and her email addresses that they needed separate cards so they could be addressed independently when creating emails.

     

    Another approach would be to edit the Spouse names to add a distinctive prefix to the name, one that could be used in a Find and Replace operation. For instance, if "Brenda" became "_Brenda" in the Spouse field, you could use Find and Replace in the Merged document to substitute " and " for "_".

     

    Lastly, you could drag your entire Group to Numbers and in Numbers create a merge source column that combined the couples' names in a way that could be used as one reference in the Mail Merge from Numbers.

     

    Hope this gives you some options to consider.

     

    Jerry

  • Jeffrey Jones2 Level 6 Level 6 (8,425 points)
    Currently Being Moderated
    Dec 4, 2012 9:40 AM (in response to Jerrold Green1)

    It seems that Contacts in Mountain Lion has dropped the Spouse field. I don't recall ever using a Spouse field, but I assume that it was there since you're using it.

    The field is called Related Name. Spouse is an option in a pop-up in the Related Name field.

  • PeterBreis0807 Level 7 Level 7 (27,255 points)
    Currently Being Moderated
    Dec 4, 2012 10:44 PM (in response to ImaBowhunter)

    A simple work around is create a special set of entries in Address Book where you treat the couple as one entity ie First Name: Christopher and Brenda.

     

    Make a special group called say "Couples"

     

    Then use the Couple group for your merges where you require them to be addressed together.

     

    Peter

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.