Merge Dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gladys - 09 Dec 2004 17:07 GMT

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 to this Message

Doug Robbins - 10 Dec 2004 02:25 GMT

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.

Signature

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

>I am trying to use Word 2003.
>
[quoted text clipped - 28 lines]
>
> Hope this makes sense. Any suggestions would be very helpful.

Reply to this Message

Gladys - 10 Dec 2004 15:35 GMT

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

> 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
[quoted text clipped - 36 lines]
> >
> > Hope this makes sense. Any suggestions would be very helpful.

Reply to this Message

Doug Robbins - 11 Dec 2004 00:26 GMT

I do not know what you did wrong, but I cannot replicate the problem in Word
2003.

Signature

> Hi Doug,
>
[quoted text clipped - 61 lines]
>> >
>> > Hope this makes sense. Any suggestions would be very helpful.

Reply to this Message

Graham Mayor - 11 Dec 2004 08:49 GMT

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi Doug,
>
[quoted text clipped - 61 lines]
>>>
>>> Hope this makes sense. Any suggestions would be very helpful.

Reply to this Message