mail merge omitting one record per page

[rogerbil]

I'm using Word X 2004 and have a problem with mail merging labels. I
have used an Avery template and correctly (?) filled in the merge
commands. When the merge is calculated, to screen, one record is
omitted at the foot of every page. I could understand it if it was a
whole row - wring label dimensions for page etc - but I don't know why
just one record should be omitted.

Roger

 

[CyberTaz]

Hi Roger -

Unusual situation, but before it can be addressed there is additional info
needed as well as some clarification ...

There is no "Word X 2004" - Office:Mac X & Office:Mac 2004 are two separate
releases of the Office:Mac suite. It would not only be helpful to know which
one you're actually using but also what specific update level of that
version. Additionally, you've not mentioned what version of OS X you're
running - again, specific update level may be a factor so please supply
those details. Lack of updates is one of the first suspects.

Further, is it a record that is omitted consistantly rfrom the same location
on each sheet - such as the last one at the bottom of the right-most
column - or is it randomly dropping "one" of the records that should be in
the bottom row? Does the omitted record appear on the next page or is it
left out entirely?

What is the record source type for the merge: Word table, Excel file...?
Have you examined it to see if there is something about it that may account
for the behavior? Are you including anything other than the basic fields
(such as IF statements or other fancy stuff)?

Can you supply any additional descriptive factors?

 

[rogerbil]

Hi Roger -

Unusual situation, but before it can be addressed there is additional info
needed as well as some clarification ...

There is no "Word X 2004" - Office:Mac X & Office:Mac 2004 are two separate
releases of the Office:Mac suite. It would not only be helpful to know which
one you're actually using but also what specific update level of that
version. Additionally, you've not mentioned what version of OS X you're
running - again, specific update level may be a factor so please supply
those details. Lack of updates is one of the first suspects.

Further, is it a record that is omitted consistantly rfrom the same location
on each sheet - such as the last one at the bottom of the right-most
column - or is it randomly dropping "one" of the records that should be in
the bottom row? Does the omitted record appear on the next page or is it
left out entirely?

What is the record source type for the merge: Word table, Excel file...?
Have you examined it to see if there is something about it that may account
for the behavior? Are you including anything other than the basic fields
(such as IF statements or other fancy stuff)?

Can you supply any additional descriptive factors?

Sorry, Word X Servicepack 1,; OSX 10.4.11, The record that is omitted
falls at the bottom of the right column (three across) - it is omitted
entirely on every page, no matter what the contents of data source,
which is a tab-delimited text file - if I delete a record on the
source a different record is omitted from the merged document. Each
label ends with the command NextRecord.

 

[CyberTaz]

OK, SP1 is 10.1.0, so it's pointless to troubleshoot any further until
Office is fully updated. Here's the site if you don't have it:

<http://www.microsoft.com/downloads/details.aspx?familyid=FEA9FD8A-EA16-4B3C
-9381-18A389D5599A&displaylang=en>

Repair disk permissions after applying the update then restart your Mac. Let
us know how you make out.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[rogerbil]

OK, SP1 is 10.1.0, so it's pointless to troubleshoot any further until
Office is fully updated. Here's the site if you don't have it:

<http://www.microsoft.com/downloads/details.aspx?familyid=FEA9FD8A-EA1....
-9381-18A389D5599A&displaylang=en>

Repair disk permissions after applying the update then restart your Mac. Let
us know how you make out.

Regards |:>)
Bob Jones
[MVP] Office:Mac

OK, the latest update I can find is 10.1.9. Applied with great
difficulty asapplication kept crashing - could only install after a
safe boot. GetInfo on Word shows application is now 10.1.8 - AboutWord
sstill shows only Service Pack 1.

Anyway, it makes no difference - still omits one record per page.

I've just run the merge using Word 2004 with the same documents. The
result is exactly the same - one record omitted per page

Grateful for your help

Regards

Roger

 

[Peter Jamieson]

If you have a { NEXT } field (<<Nextrecord>>) at the beginning of the
/first/ label, delete it.

I wasn't quite sure whether you meant that one of the labels on the page
was always blank, or whether merge was skipping a record - if it's
"skipping", but a full page of labels is always printed, you probably
have one more { NEXT } than you need.

Peter Jamieson

http://tips.pjmsn.me.uk

 

[rogerbil]

If you have a { NEXT } field (<<Nextrecord>>) at the beginning of the
/first/ label, delete it.

I wasn't quite sure whether you meant that one of the labels on the page
was always blank, or whether merge was skipping a record - if it's
"skipping", but a full page of labels is always printed, you probably
have one more { NEXT } than you need.

Peter Jamieson

http://tips.pjmsn.me.uk

Thanks for the clue. I have just removed the «Next Record» from the
last label on the page and it now formats correctly.

Regards

Roger

 

[Peter Jamieson]

Typically, Word puts its { NEXT } fields at the beginning of each table
cell, except the first on the page (although I'm not so familiar with
the Mac world where that may be different). But if you have yours at the
end of each cell including the first cell, yes, removing the last one on
the page would be the right thing to do.


Peter Jamieson

http://tips.pjmsn.me.uk