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