Mail Merge Problem

[smallabc]

Hi, I have an excel with following data

Name Course Score

X Literature 88

X History 85

Y Maths 83

Z Literature 67

X Maths 89

Y Literature 77

In total there are 3 courses, Literature, History , Maths.

I have a Word document to use mail merge as follows:

<<Course>>

<<Student >> <<Score>>

I would to print page course by course, i.e.

The outcome will be something this:

Doc Page 1:

Literature

X 88

Z 67

Y 77

Doc Page 2:

History

X 85

Doc Page 3:

Maths

Y 83

X 89

Is it achievable by mail merge??

 

[macropod]

Cross-posted and COMPREHENSIVELY ANSWERED BEFORE POSTING HERE, at:
http://www.vbaexpress.com/forum/showthread.php?59466-Mail-merge-problem
and:
https://answers.microsoft.com/en-us...-problem/1999c64b-e364-453e-9450-b47c96c91c2d
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184