Skip navigation

Mail Merge Funnies

189 Views 3 Replies Latest reply: Nov 21, 2013 12:10 PM by MalcW RSS
MalcW Level 1 Level 1 (30 points)
Currently Being Moderated
Nov 21, 2013 9:03 AM

I am using Pages '09 version 4.3 and Numbers '09 Version 2.3.

 

The data list is in Numbers and I have prepared the form letter in Pages with the first line showing "Dear Name". The idea is that the "name" is picked up from the list in the numbers spreadsheet.  Everything works fine but.....when the mail merged document is produced I found the following strange behaviour.  Any name in the Numbers Spreadsheet which contains more than 14 characters (including spaces) causes the resultant merged document to spread the whole "Dear Fred" or whatever - over two lines. It spaces out the letters which cause them to run into the next line - which of course wrecks the entire merge as that particular page now runs onto two pages instead of one.

 

As long as the "Name" is less than 14 characters there's no problem.  Even typing the name over one that has been merged correctly goes awol after the 14th character.

 

So, is there a limit to the number of characters that you can have in a field and can this be amended?

MacBook Pro (Retina, Mid 2012), OS X Mountain Lion (10.8.5), Using external Cinema Display
  • Jerrold Green1 Level 7 Level 7 (28,270 points)
    Currently Being Moderated
    Nov 21, 2013 9:53 AM (in response to MalcW)

    Malc,

     

    Consider yourself lucky to still have Mail Merge at all. It's missing from the new version of iWork apps.

     

    No, there's no character limit if you know how to deal with large strings, and those problems don't begin until you have 255 characters or more. Your problem with medium length strings is likely to be in the Pages document.

     

    What happens if you just type over the link with 15 characters or more?

     

    Jerry

  • fruhulda Level 6 Level 6 (14,830 points)
    Currently Being Moderated
    Nov 21, 2013 10:21 AM (in response to Jerrold Green1)

    Jerry, don't say you haven't iWork 09 anymore? I don't believe you!

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.