#1   Report Post  
Gladys
 
Posts: n/a
Default Merge Dates

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   Report Post  
Doug Robbins
 
Posts: n/a
Default

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   Report Post  
Gladys
 
Posts: n/a
Default

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   Report Post  
Doug Robbins
 
Posts: n/a
Default

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   Report Post  
Graham Mayor
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 01:55 AM
suppress invalid merge field word 2003 Mike Mailmerge 3 December 9th 04 11:13 AM
Mail merge toolbar unavailable after SP3 R Scott Lowden Mailmerge 1 December 1st 04 06:24 PM
Excel dates formatted d/m/yy convert to m/d/yy in mail merge GayleT Mailmerge 1 November 29th 04 02:43 AM
Merge Data Source path Peter Jamieson Mailmerge 0 November 25th 04 07:15 PM


All times are GMT +1. The time now is 04:37 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"