word+excel mail merge omits 1st numeric record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JDavidson - 11 Jan 2006 11:28 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 11 Jan 2006 12:09 GMT

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

Signature

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

> Mail merge works fine, it copies :
>
[quoted text clipped - 9 lines]
>
> Anybody know why it is always omitting the 1st numeric record?

Reply to this Message

JDavidson - 11 Jan 2006 13:18 GMT

Thanks for the quick reply,

I did have a <<next record>> after the last subject field but even with that
removed it still omits the first record of the assessed level and effort
fields and automatically fills in the next record from the excel row.

very confusing.

> You probably have a <<Next Record>> field between the Subject and Assessed
> level mergefields.
[quoted text clipped - 12 lines]
> >
> > Anybody know why it is always omitting the 1st numeric record?

Reply to this Message

Doug Robbins - Word MVP - 11 Jan 2006 18:52 GMT

Are you trying to merge multiple subjects, assessed levels and efforts for
each Surname, Forename, Form, Teacher?

Exactly how is your data source arranged?

Signature

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

> Thanks for the quick reply,
>
[quoted text clipped - 27 lines]
>> >
>> > Anybody know why it is always omitting the 1st numeric record?

Reply to this Message

JDavidson - 12 Jan 2006 09:36 GMT

The excel sheet has 13 rows per pupil, each containing :
surname > forename > reg > Teacher > subject > level > effort

In the word template this is then condensed into :
name (surname+forename) and reg at the top,
then with a column for subject, column for teacher, column for level and a
column for effort.

Everything enters correctly into the form, with the exception that the 1st
level and effort rows from the excel sheet are missing.

> Are you trying to merge multiple subjects, assessed levels and efforts for
> each Surname, Forename, Form, Teacher?
[quoted text clipped - 32 lines]
> >> >
> >> > Anybody know why it is always omitting the 1st numeric record?

Reply to this Message

Doug Robbins - Word MVP - 12 Jan 2006 11:15 GMT

You are trying to perform a "multiple items per condition (=key field)"
mailmerge which Word does not really have the ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Articles

http://support.microsoft.com/default.aspx?scid=kb;en-us;302665

http://support.microsoft.com/default.aspx?scid=kb;en-us;294686

Signature

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

> The excel sheet has 13 rows per pupil, each containing :
> surname > forename > reg > Teacher > subject > level > effort
[quoted text clipped - 48 lines]
>> >> >
>> >> > Anybody know why it is always omitting the 1st numeric record?

Reply to this Message