View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default MAC WORD 2004 - Data Merge creating error

1. In this case, could you connect to the Office Address Book instead of
exporting (I think that you get a reduced number of fields).

2. When you export, do you get a tab-delimited file? I find here that I have
to add a column to the header to get the number of fields in the records to
match the number in the header. However, I have not yet worked out which
column is missing (The last one here is "Interests").

3. I would look for two types of problem in the data:
a. use of delimiter characters (either tab or, more likely I think, Enter,
or possibly even double-quote characters) in the data itself. Entourage does
not appear to export tabs that occur in the data but I haven't checked what
happens with any of the other possibilities
b. very long lines, if your Address book/Contacts entries have lots of
information in them.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"fidelio1st" wrote in message
...
Thanks for your response. I actually found the Data Merge Manager under
File
instead of Tools. Now I'm working on a template in Word to Data Merge.

Another problem came up:

I exported my Entourage Address Book to a CSV file. When I do a data
merge,
it comes up with an error that says: "Record 16 does not have the same
number
as the first row in ContactsExport.csv. Ensure all the records have the
same
number of fields."


So I deleted all columns after the last one with a header. I even deleted
row 16 and saved under a different file name, then reopened in the data
merge, and it came up with the same error. (FYI there are 1465
records/rows
of contacts)