Merging with an Excel file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cathy - 19 Aug 2004 15:15 GMT

I am doing a merge with an excel file but when I do the
merge, it is only selecting every other record (ie. only
line 2, 4, 6, of the excel fileetc.). Can someone please
advise how I get all the records to merge (as a work
around I am inserting rows so that data on all even lines
but this won't work as I have cell reference files).

Also, how do I get a page break at the end of each record.

I'm working in WORD 2000.

Reply to this Message

Doug Robbins - 20 Aug 2004 00:55 GMT

It sounds like you must be using a catalog type mailmerge main document and
you have a <<Next Record>> fileld there where it is not required.

You will achieve both of your aims if you use a formletter type mailmerge
main document. You will then automatically get a next page section break
between each record.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I am doing a merge with an excel file but when I do the
> merge, it is only selecting every other record (ie. only
[quoted text clipped - 6 lines]
>
> I'm working in WORD 2000.

Reply to this Message