If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
mail merge w/ word and excel
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
mail merge w/ word and excel
Are you using a DDE connection or ODBC? We do alot of mail merges and had some problems with Excel following an update; I found an article which said the binary transport method of Excel had been changed. To get around erratic behavior in Excel, setup a System DSN and connect via ODBC and everything works fine. If you need to know how to do either of those things, please let me know and I will provide instructions. Good luck. Victoria ------------------------------------------------ ~~ Message posted from http://www.WordForums.com/ |
#4
|
|||
|
|||
mail merge w/ word and excel
thanks for your help (graham and victoria) ! you are both lifesavers!
Jennifer |
Thread Tools | |
Display Modes | |
|
|