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  

Word mail merge with Excel data



 
 
Thread Tools Display Modes
  #1  
Old April 26th, 2004, 06:31 PM
Peter Jamieson
external usenet poster
 
Posts: n/a
Default Word mail merge with Excel data

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.

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

"Sheryl" wrote in message
...
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?

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?

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

"Sheryl" wrote in

message
...
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!



.



  #2  
Old April 26th, 2004, 07:30 PM
Sheryl
external usenet poster
 
Posts: n/a
Default Word mail merge with Excel data

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
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.

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

"Sheryl" wrote in

message
...
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?

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?

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

"Sheryl" wrote in

message
...
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!


.



.

 




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 05:30 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.