View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
JSBAssoc JSBAssoc is offline
external usenet poster
 
Posts: 1
Default Mailmerge data source give error after 32 fields

I have a simple header file i am using to create a merge document. the
entirety of the .csv file is the folowing two lines:
Finder number,Source code,Expiration date,Given by,Is gift?,Join date,Last
renewed on,Member,Membership level,Membership program,Membership
term,Membership type,Send renewal notice to,Status,Address,Address Line
1,Address Line 2,Address Line 3,Address Line 4,Address Line
5,Addressee,Age,CART,City,Contact addressee,Country,Country
abbreviation,DPC,Email address,First gift date,First name,Gender,Head of
household,Is household,Key name prefix,Last name/Organization name,LOT,Middle
name,Name,Phone number,Salutation,State,State abbreviation,Suffix,Suffix
2,Title,Title 2,ZIP
Finder number,Source code,Expiration date,Given by,Is gift?,Join
date,Last renewed on,Member,Membership level,Membership
program,Membership term,Membership type,Send renewal notice
to,Status,Address,Address Line 1,Address Line 2,Address Line
3,Address Line 4,Address Line 5,Addressee,Age,CART,City,Contact
addressee,Country,Country abbreviation,DPC,Email address,First gift
date,First name,Gender,Head of household,Is household,Key name
prefix,Last name/Organization name,LOT,Middle name,Name,Phone
number,Salutation,State,State abbreviation,Suffix,Suffix
2,Title,Title 2,ZIP

When I choose this file for my recipient list, Word (2007) cannot see the
data. Instead it lists about a dozen commas and tells me there is no data in
teh file if I select OK on the dialog.

If i knock off fields from the end until there are only 32 fields it will
work. If I take out the angle brackets from the 2nd row (the data row) so
that the tow rows are identical, it will work. I even created a 2nd file with
simply "m1, m2, ..." all the way to 50 and it worked (even with brackets on
the data row "m1, ...")

I can't figure it out. The header file is built by a separate program so I
can't change it (except for the # of fields I output).

Does anyone have any clue how I could proceed?