View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mailmerge data source give error after 32 fields

I am pretty sure that your problem is caused by the spaces in the field
names (the first row in your data source) that causes Word substitute a
default field name for them and that it only accommodates 32 default field
names.

That would explain why your m1,m2 up to m50 works (i.e. no spaces)

So try deleting the spaces from the field names in the first row. Note, if
your data also contains spaces, you may need to enclose each field in ""
Particularly if some of the data contains commas, such as Pickering, Jr

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"JSBAssoc" wrote in message
...
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?