Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying to use Word 2003.
I have a datasource set up in Excel showing me every Monday and Tuesday for 2005. I've created a Word 2003 document that has two tables on a page (mini calendars) - In a cell in the table on the top half of page I have the mergefield and then next record. On the second table I insert the merge field. When I merge the records the 1st page looks ok. But on the next page it repeats the mergefield from the 2nd table, to the area at the top of the page. I tested this in Word 2000 and it works fine. Here is an Example on how the data is being merged. 1st Page Top Half - Mergefield = Monday, January 03, 2005 Bottom Half - Mergefield = Tuesday, January 04, 2005 2nd page Top Half - Mergefield = Tuesday, January 04, 2005 Bottom Half - Mergefield - Monday, January 10, 2005 3rd Page Top Half - Mergefield = Monday, January 10, 2005 Bottom Half - Mergefield - Tuesday, January 11, 2005 Hope this makes sense. Any suggestions would be very helpful. |
#2
![]() |
|||
|
|||
![]()
If the document were set up as a label type mailmerge, then it should work.
An alternative is to create the mailmerge main documnet as a Directory type mailmerge document and just have one table in it and have the dimensions of the rows in that table fixed so that it takes up half of the page and only one more table will fit on the page. If you want them as separate tables, not joined together, have two paragraph returns after the table. With this arrangement you will not need a Next Record field. -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "Gladys" wrote in message ... I am trying to use Word 2003. I have a datasource set up in Excel showing me every Monday and Tuesday for 2005. I've created a Word 2003 document that has two tables on a page (mini calendars) - In a cell in the table on the top half of page I have the mergefield and then next record. On the second table I insert the merge field. When I merge the records the 1st page looks ok. But on the next page it repeats the mergefield from the 2nd table, to the area at the top of the page. I tested this in Word 2000 and it works fine. Here is an Example on how the data is being merged. 1st Page Top Half - Mergefield = Monday, January 03, 2005 Bottom Half - Mergefield = Tuesday, January 04, 2005 2nd page Top Half - Mergefield = Tuesday, January 04, 2005 Bottom Half - Mergefield - Monday, January 10, 2005 3rd Page Top Half - Mergefield = Monday, January 10, 2005 Bottom Half - Mergefield - Tuesday, January 11, 2005 Hope this makes sense. Any suggestions would be very helpful. |
#3
![]() |
|||
|
|||
![]()
Hi Doug,
Thanks for your suggestions but they didn't work. I even tried from a blank document using default label selections. I still have the same problem. I did get it to work by changing by datasource. In excel I made one column to refer to as "Monday" and another as "Tuesday" instead of all of the dates in one field. It boggles me how it works in 2000 but not in our Latest Greatest Versions ![]() Thanks again for your assitance. Gladys "Doug Robbins" wrote: If the document were set up as a label type mailmerge, then it should work. An alternative is to create the mailmerge main documnet as a Directory type mailmerge document and just have one table in it and have the dimensions of the rows in that table fixed so that it takes up half of the page and only one more table will fit on the page. If you want them as separate tables, not joined together, have two paragraph returns after the table. With this arrangement you will not need a Next Record field. -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "Gladys" wrote in message ... I am trying to use Word 2003. I have a datasource set up in Excel showing me every Monday and Tuesday for 2005. I've created a Word 2003 document that has two tables on a page (mini calendars) - In a cell in the table on the top half of page I have the mergefield and then next record. On the second table I insert the merge field. When I merge the records the 1st page looks ok. But on the next page it repeats the mergefield from the 2nd table, to the area at the top of the page. I tested this in Word 2000 and it works fine. Here is an Example on how the data is being merged. 1st Page Top Half - Mergefield = Monday, January 03, 2005 Bottom Half - Mergefield = Tuesday, January 04, 2005 2nd page Top Half - Mergefield = Tuesday, January 04, 2005 Bottom Half - Mergefield - Monday, January 10, 2005 3rd Page Top Half - Mergefield = Monday, January 10, 2005 Bottom Half - Mergefield - Tuesday, January 11, 2005 Hope this makes sense. Any suggestions would be very helpful. |
#4
![]() |
|||
|
|||
![]()
I do not know what you did wrong, but I cannot replicate the problem in Word
2003. -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "Gladys" wrote in message ... Hi Doug, Thanks for your suggestions but they didn't work. I even tried from a blank document using default label selections. I still have the same problem. I did get it to work by changing by datasource. In excel I made one column to refer to as "Monday" and another as "Tuesday" instead of all of the dates in one field. It boggles me how it works in 2000 but not in our Latest Greatest Versions ![]() Thanks again for your assitance. Gladys "Doug Robbins" wrote: If the document were set up as a label type mailmerge, then it should work. An alternative is to create the mailmerge main documnet as a Directory type mailmerge document and just have one table in it and have the dimensions of the rows in that table fixed so that it takes up half of the page and only one more table will fit on the page. If you want them as separate tables, not joined together, have two paragraph returns after the table. With this arrangement you will not need a Next Record field. -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "Gladys" wrote in message ... I am trying to use Word 2003. I have a datasource set up in Excel showing me every Monday and Tuesday for 2005. I've created a Word 2003 document that has two tables on a page (mini calendars) - In a cell in the table on the top half of page I have the mergefield and then next record. On the second table I insert the merge field. When I merge the records the 1st page looks ok. But on the next page it repeats the mergefield from the 2nd table, to the area at the top of the page. I tested this in Word 2000 and it works fine. Here is an Example on how the data is being merged. 1st Page Top Half - Mergefield = Monday, January 03, 2005 Bottom Half - Mergefield = Tuesday, January 04, 2005 2nd page Top Half - Mergefield = Tuesday, January 04, 2005 Bottom Half - Mergefield - Monday, January 10, 2005 3rd Page Top Half - Mergefield = Monday, January 10, 2005 Bottom Half - Mergefield - Tuesday, January 11, 2005 Hope this makes sense. Any suggestions would be very helpful. |
#5
![]() |
|||
|
|||
![]()
The main difference between Word 2000 and the later versions is the method
by which merges are connected to their data. I did however create an Excel file containing the same data and attempted to reproduce your problem, using the old and new methods of connection to Excel. The only anomaly I could see was the position of the NEXT field in the first cell rather than at the start of the second cell, but that did not cause your problem to be reproduced here. See the Excel data section of http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Gladys wrote: Hi Doug, Thanks for your suggestions but they didn't work. I even tried from a blank document using default label selections. I still have the same problem. I did get it to work by changing by datasource. In excel I made one column to refer to as "Monday" and another as "Tuesday" instead of all of the dates in one field. It boggles me how it works in 2000 but not in our Latest Greatest Versions ![]() Thanks again for your assitance. Gladys "Doug Robbins" wrote: If the document were set up as a label type mailmerge, then it should work. An alternative is to create the mailmerge main documnet as a Directory type mailmerge document and just have one table in it and have the dimensions of the rows in that table fixed so that it takes up half of the page and only one more table will fit on the page. If you want them as separate tables, not joined together, have two paragraph returns after the table. With this arrangement you will not need a Next Record field. -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "Gladys" wrote in message ... I am trying to use Word 2003. I have a datasource set up in Excel showing me every Monday and Tuesday for 2005. I've created a Word 2003 document that has two tables on a page (mini calendars) - In a cell in the table on the top half of page I have the mergefield and then next record. On the second table I insert the merge field. When I merge the records the 1st page looks ok. But on the next page it repeats the mergefield from the 2nd table, to the area at the top of the page. I tested this in Word 2000 and it works fine. Here is an Example on how the data is being merged. 1st Page Top Half - Mergefield = Monday, January 03, 2005 Bottom Half - Mergefield = Tuesday, January 04, 2005 2nd page Top Half - Mergefield = Tuesday, January 04, 2005 Bottom Half - Mergefield - Monday, January 10, 2005 3rd Page Top Half - Mergefield = Monday, January 10, 2005 Bottom Half - Mergefield - Tuesday, January 11, 2005 Hope this makes sense. Any suggestions would be very helpful. |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mail Merge Word 2003 Issue | Mailmerge | |||
suppress invalid merge field word 2003 | Mailmerge | |||
Mail merge toolbar unavailable after SP3 | Mailmerge | |||
Excel dates formatted d/m/yy convert to m/d/yy in mail merge | Mailmerge | |||
Merge Data Source path | Mailmerge |