Mail Merge Error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fidelio1st - 30 Oct 2007 20:41 GMT

[I posted this under my other posting, but felt I should give own subject, so
if answered under other, no need to duplicate, thanks]

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)

How do I fix this? Is the csv corrupted? I've tried exporting a couple
different times.

Reply to this Message

Graham Mayor - 31 Oct 2007 11:04 GMT

Convert the text to a table in Word and merge again using the table as a
data source.
http://www.gmayor.com/convert_labels_into_mail_merge.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> [I posted this under my other posting, but felt I should give own
> subject, so if answered under other, no need to duplicate, thanks]
[quoted text clipped - 11 lines]
> How do I fix this? Is the csv corrupted? I've tried exporting a
> couple different times.

Reply to this Message

fidelio1st - 31 Oct 2007 18:27 GMT

Hi Graham,
Thanks for responding. I don't understand what you mean. I exported my
data from Entourage Address Book into a .csv file. So it's already in a
table in excel. I'm not sure what you mean by having it as text in Word. I
know how to covert text to table, but I'm not sure how I get the text from
the csv file, or why I would do that?

The problem I'm having is with the merge, there may be something corrupted
with the csv file, but I'm not sure how to correct it.

Confused.

> Convert the text to a table in Word and merge again using the table as a
> data source.
[quoted text clipped - 15 lines]
> > How do I fix this? Is the csv corrupted? I've tried exporting a
> > couple different times.

Reply to this Message

Graham Mayor - 01 Nov 2007 07:54 GMT

Word can merge from a variety of data sources, but the one it likes best is
a Word table. CSV files can confuse the issue and it seems that yours has a
problem with record 16. Converting the CSV file to a table should eliminate
that problem. If you prefer you can merge directly from an Excel Wordsheet.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi Graham,
> Thanks for responding. I don't understand what you mean. I exported
[quoted text clipped - 35 lines]
>>> How do I fix this? Is the csv corrupted? I've tried exporting a
>>> couple different times.

Reply to this Message

Rate this thread: