mail merge w/ word and excel

[jmorris]

I have windows 2000 and office xp


1. When I do a merge from excel into word (either labels or a form letter) the first page comes out fine. The next page skips a record. Lets say I'm merging address A, B, C, D, E, and F, etc.. the first page, for example would contain Address A B C D then when going to the next page, it would skip E and go to F, G, H, etc..This happened on all of the pages in my merge. I do have next record in each cell when setting up the merge fields. If I don't, it will just repeat the first address over and over again

2. This is a weird one: After I do a mail merge (either labels or a form letter) i can't open an excel file by double clicking on the file. I have to open excel first then open the file.

Any suggestions

 

[Graham Mayor]

You don't need a NEXT field in a form letter merge and in a label merge you
should not have a next field in the first cell.
If you use the tools provided with Word to create the correct kind of merge
Word puts the next fields only where they are required. See
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[vree]

Are you using a DDE connection or ODBC? We do alot of mail merges an
had some problems with Excel following an update; I found an articl
which said the binary transport method of Excel had been changed. T
get around erratic behavior in Excel, setup a System DSN and connec
via ODBC and everything works fine.

If you need to know how to do either of those things, please let m
know and I will provide instructions.

Good luck.
Victori