A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

mail merge w/ word and excel



 
 
Thread Tools Display Modes
  #1  
Old May 3rd, 2004, 11:46 PM
jmorris
external usenet poster
 
Posts: n/a
Default 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  
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?



  #3  
Old May 4th, 2004, 02:25 PM
vree
external usenet poster
 
Posts: n/a
Default 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  
Old May 5th, 2004, 03:36 PM
jmorris
external usenet poster
 
Posts: n/a
Default mail merge w/ word and excel

thanks for your help (graham and victoria) ! you are both lifesavers!

Jennifer
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:25 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.