2010 Mail Merge either skipping first record or skipping multiple records

[Frumpy Jones]

*sigh*. I know I SHOULD be able to figure this out. I have mail-merge
so many times in my life that I should figure this out. But I have tw
small kids now, and one is crying behind me as I type this, so forgiv
me...

I am trying to merge an excel spreadsheet into a document with mutipl
records/hits on each page (5 to be exact). It's as simple as using onl
Data 1 and Next Record

If I start off with ONLY Data 1, it skips the first called-fiel
entirely, and then the rest of the stuff starts at field two (which ha
next record Data 1

However if I add Next record to the first field, it ends up skipping on
item per page made (The list is always multiples of 5, so if I have 1
items in the list, it's skipping record 6 and record 12)

Here's how it kinda looks:


Code
-------------------
First Scenario:

Text text text text {Data 1}
Text text text text {Next Record} {Data 1}
Text text text text {Next Record} {Data 1}
Text text text text {Next Record} {Data 1}
Text text text text {Next Record} {Data 1}
Output:

Text text text text (No data files to this)
Text text text text A
Text text text text B
Text text text text C
Text text text text D
(new page)
Text text text text E
Text text text text F

-------------------



Code
-------------------
Second Scenario:

Text text text text {Next Record} {Data 1}
Text text text text {Next Record} {Data 1}
Text text text text {Next Record} {Data 1}
Text text text text {Next Record} {Data 1}
Text text text text {Next Record} {Data 1}

Output:

Text text text text A
Text text text text B
Text text text text C
Text text text text D
Text text text text E
(new page)
Text text text text *G*

-------------------


I am very frustrated as I have about 1000 items to merge.... And m
first thought was to just put bogs data in the first record and us
Scenario 1.. But I feel I shouldn't have to.

Thanks in advance for any help

 

[Suzanne S. Barnhill]

A Directory-type merge requires you to have the merge field just once, with
no «Next Record» field at all. A Labels-type merge requires «Next Record» at
the beginning of each label after the first.

"Frumpy Jones" wrote in message

*sigh*. I know I SHOULD be able to figure this out. I have mail-merged
so many times in my life that I should figure this out. But I have two
small kids now, and one is crying behind me as I type this, so forgive
me...

I am trying to merge an excel spreadsheet into a document with mutiple
records/hits on each page (5 to be exact). It's as simple as using only
Data 1 and Next Record

If I start off with ONLY Data 1, it skips the first called-field
entirely, and then the rest of the stuff starts at field two (which has
next record Data 1

However if I add Next record to the first field, it ends up skipping one
item per page made (The list is always multiples of 5, so if I have 15
items in the list, it's skipping record 6 and record 12)

Here's how it kinda looks:


Code:
--------------------
First Scenario:

Text text text text {Data 1}
Text text text text {Next Record} {Data 1}
Text text text text {Next Record} {Data 1}
Text text text text {Next Record} {Data 1}
Text text text text {Next Record} {Data 1}
Output:

Text text text text (No data files to this)
Text text text text A
Text text text text B
Text text text text C
Text text text text D
(new page)
Text text text text E
Text text text text F

--------------------



Code:
--------------------
Second Scenario:

Text text text text {Next Record} {Data 1}
Text text text text {Next Record} {Data 1}
Text text text text {Next Record} {Data 1}
Text text text text {Next Record} {Data 1}
Text text text text {Next Record} {Data 1}

Output:

Text text text text A
Text text text text B
Text text text text C
Text text text text D
Text text text text E
(new page)
Text text text text *G*

--------------------


I am very frustrated as I have about 1000 items to merge.... And my
first thought was to just put bogs data in the first record and use
Scenario 1.. But I feel I shouldn't have to.

Thanks in advance for any help.