NoOp wrote:
On 04/15/2008 08:10 AM, H.S. wrote:
Hello,
Just wanted to share the experience that the presence of any periods in
the title row of a spread sheet may mess up the mail merge fields. For
example, "P.C." title of a column creates weird problems in mail merge
but changing it to "Postal Code" fixes it. It appears that since periods
are used as separators in the address book fields, the periods in the
title row may be messing things up.
Can anybody confirm this or give more information regarding this?
thanks,
->HS
What sort of "wierd problems"? It's also helpful if you let us know what
version of OOo & Operating System...
I was printing labels using the data. Initially, all the labels turned
out to be the same. If I created the labels by using only the fields
which had no period in them, then the data came out okay.
I then tried to delete the fields from the first label and synchronized
others, and then added each field from the address source (got by
pressing F4) by clicking on the field and dragging it. As long as I
included fields with no periods, everything worked, but as soon as I
included fields with periods, though I got all different data in each
label, but the _first sample_ of data was missing from the columns with
title including a period.
This was on OOo 2.4 on Windows as well on Debian Sid.
I cannot recreate on OOo 2.4.0 (linux). I used an .ods that originally
used "zip" (postal code - zip code in US) in the column header and
changed it to P.C. I then opened a new mailmerge and pointed to the .ods
as the source & identified "P.C" as the Zip field. No problem - postal
code was put in the letter(s) properly.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
