mail merge w/ word and excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jmorris - 03 May 2004 23:46 GMT

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

Reply to this Message

Graham Mayor - 04 May 2004 08:51 GMT

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

Signature

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

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

> I have windows 2000 and office xp.
>
[quoted text clipped - 12 lines]
>
> Any suggestions?

Reply to this Message

vree - 04 May 2004 14:25 GMT

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

Reply to this Message