Directory and merge from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Murph - 30 Apr 2008 21:34 GMT

I am using Excel 07 and Word 07.

I am trying to merge the data in .csv form into Word. I am doing this using
the mail merge feature and selecting 'directory'.

I match the fields and place them in the document and then use the rule of
'next record' in hopes that it will keep placing the records with the same
format as the first. When I click preview I only see the first record and
when I do a 'finish and merge' Word locks up. There are 1755 records.

I amd doing this on the first line of the page:
«LastName», «FirstName» & «Spouse»
«Address1», «Address2», «City», «State», «ZIPCode» «HomePhone»
«Children»

«Next Record»

«Next Record»

«Next Record»

In return I only receive the first record

A., Kristopher & Cyndi
1022 Ae, , Indianapolis, IN, 46227 ### ### ####
Ceer

thoughts?

Reply to this Message

Doug Robbins - Word MVP - 30 Apr 2008 22:35 GMT

You do not need the Next Record field. Also a preview will not show the
result of executing the merge. Just execute the merge to a new document and
you should get what you want.

Signature

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

>I am using Excel 07 and Word 07.
>
[quoted text clipped - 25 lines]
>
> thoughts?

Reply to this Message