Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2004

Tip: Looking for answers? Try searching our database.

Word mail merge with Excel data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sheryl - 22 Apr 2004 20:15 GMT
I have created a form in Word to merge spreadsheet data
into.  When merging all the data fills al the fields
correctly except for page three of the Excel spreadsheet,
the data on page three is shifting over two slots to the
right of where it belongs on the form.  For example,
Street is in the zip code box, city is in the Phone field
etc on the form.  The Excel pages 1 and 2 are in their
correct locations on the merge to form.  I went in and
updated the merge fields twice and it continues.  I took
page three of the Excel data and made it into its own
document and merged as a test to see if there was
something wrong with the fields - it worked perfectly.  Is
there a limitation of pages or fields between an Excel and
Word merge?  Is there a way around this?  Please help!
Peter Jamieson - 23 Apr 2004 07:54 GMT
Which version of Excel/Word?

Are these Excel "pages" separate worksheets, or something else?

If they are worksheets,
a. how are you getting them to merge all at the same time?
b. do they have exactly the same columns n the same positions as the other
worksheets?

Signature

Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> I have created a form in Word to merge spreadsheet data
> into.  When merging all the data fills al the fields
[quoted text clipped - 10 lines]
> there a limitation of pages or fields between an Excel and
> Word merge?  Is there a way around this?  Please help!
Sheryl - 23 Apr 2004 13:51 GMT
I am running Word and Excel 2002.  The Excel document is
one spreadsheet with "pages" 1-3 containing the fields and
data I am trying to merge into a Word form (table).

>-----Original Message-----
>Which version of Excel/Word?
[quoted text clipped - 22 lines]
>
>.
Peter Jamieson - 26 Apr 2004 18:31 GMT
Sorry, Sheryl, I just can't make prgress on this one. If the fiels nvolved
are not too large and you are able to send them, if you like you can despam
my e-mail address and send them to me. I'll try to get back to you in the
next day or two.

Signature

Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> I am running Word and Excel 2002.  The Excel document is
> one spreadsheet with "pages" 1-3 containing the fields and
[quoted text clipped - 35 lines]
> >
> >.
Sheryl - 26 Apr 2004 19:30 GMT
Thank Peter, but the data is extremely confidential so I
can't send it to you.  I think the problem is limitations
within Word and Excel.  I found that by hiding the fields
that I don't need that it reduces down to two pages, which
are able to merge into Word. I wrestled with this one and
this is the only solution that I have been able to come up
with.  I appreciate all your trouble shooting!!  You are
definitely a MVP! Thanks!

>-----Original Message-----
>Sorry, Sheryl, I just can't make prgress on this one. If the fiels nvolved
[quoted text clipped - 43 lines]
>
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.