Merge Dates

[Gladys]

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.

 

[Doug Robbins]

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]

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]

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

 

[Graham Mayor]

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

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>