View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default word+excel mail merge omits 1st numeric record

You probably have a Next Record field between the Subject and Assessed
level mergefields.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"JDavidson" wrote in message
...
Mail merge works fine, it copies :

Surname, Forename, Form, Teacher and Subject into a template designed in
word, but then the next two columns (Assessed level and effort, which are
both numeric) the merge omits the first record for each and automatically
fills in with the next value from the following row.

The problem works out that all records are fine until the numeric grades
which dont correspond to the correct subject as they have moved 1 row up
the
template, following the merger omitting the 1st record.

Anybody know why it is always omitting the 1st numeric record?