MailMerge Word and Excel Next Record Not Work

[Susanto3311]

hi all..

how to mail merge with excel as data set/source and ms word as document
i have try using Rules but not working (next records)..
here my attachemnt picture
i hope someone give a solution
thanks in advance.

susant

[HansV]

That doesn't look like a mail merge. Why not simply copy the Excel dataset and paste it into your Word document?

[Susanto3311]

Hi Hans.. That just a sample case.
Please, i want to use mail merge for this case
Actually score1 till score4 as fields.
I hope you have solution using mail merge

[HansV]

So you could select D1:G5, copy it and paste it into Word.

[Susanto3311]

Hi Hans.. I think that's not good idea. Actually in Word document with random position and contains/skip interval row and i have thousand data/records.

[HansV]

Hmm... anyone else?

[Charles Kenyon]

This is a weak area for me, but I think you need a catalogue/directory mail merge.
See http://www.msofficeforums.com/mail-merg ... orial.html.
Paul Edstein may see this and be able to give more guidance.

[Susanto3311]

hi charles thank you but it's not easy for me