View Single Post
  #2  
Old May 4th, 2004, 08:51 AM
Graham Mayor
external usenet poster
 
Posts: n/a
Default mail merge w/ word and excel

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_lab...th_word_xp.htm

--

Graham Mayor - Word MVP

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




jmorris wrote:
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?