Merging to a Directory

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Helen - 08 Oct 2003 13:43 GMT

I want to merge records from excel (or access) into a
Directory. I can do this but I have a problem where it
skips certain records. When in landscape it skipped every
7th record (there were 6 to the page).
Doing the same thing in portrait it left out all the even
numbered ones. I used a number field in the merge to show
me what was missing.
I've created new documents and new data sources and still
have the same problems.
Any help would be much appreciated.

Reply to this Message

Cindy M -WordMVP- - 11 Oct 2003 10:31 GMT

Hi Helen,

Can you describe which steps you used to set up this
"Directory" main merge document? It sounds to me almost as if
you're doing something with the NEXT field, or with the
"labels" functionality?

Which version of Word is this?

> I want to merge records from excel (or access) into a
> Directory. I can do this but I have a problem where it
[quoted text clipped - 5 lines]
> I've created new documents and new data sources and still
> have the same problems.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)

Reply to this Message

- 27 Oct 2003 17:04 GMT

Sorry should have said we are using office XP.
In setting up the directory I have used "next record".
They are place cards for a dining table and have the name
printed twice so it shows on both sides once they are cut
up. There are 6 names to the page. It always skips
record 7. Is it the Next record field that causes the
problem? (I suspect it might be)
Does this make any sense at all??
Helen

>-----Original Message-----
>Hi Helen,
[quoted text clipped - 26 lines]
>
>.

Reply to this Message

Cindy M -WordMVP- - 27 Oct 2003 21:59 GMT

> Sorry should have said we are using office XP.
> In setting up the directory I have used "next record".
[quoted text clipped - 4 lines]
> problem? (I suspect it might be)
> Does this make any sense at all??

Yes, it's making some sense :-)

you have to be careful where you put the "Next Record"
fields. Be sure you don't have one at the beginning of the
first "box", and none after the last one. (Press Alt+F9 to
be able to see/hide the codes for ALL fields in the
document.)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

:-)

Reply to this Message

- 05 Nov 2003 11:30 GMT

Thanks, removing the last "Next Record" has fixed the
problem.

>-----Original Message-----
>> Sorry should have said we are using office XP.
[quoted text clipped - 25 lines]
>
>.

Reply to this Message