Merging with an Excel file

[cathy]

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.

 

[Doug Robbins]

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.

--
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