I have a mail merge I'm working on that appears to be a bit of a challenge.
A contract number can have more than one contract type. If I try to merge
the data below I get 7 documents (000022222, 000022222, 000022222,
000022222, 000022223, 000022223 000022225) when in fact there are only three
unique documents (000022222, 000022223, 000022225) How do I place all of the
information of a particular contract in its own document?

FYI: I cannot use Access because our company does not have it.

Contract No. Contract Title Contract Type Author
000022222 Title1 international Smith
000022222 Title1 domestic Smith
000022222 Title1 NAFTA Smith
000022222 Title1 Asia Smith
000022223 Title1 US Jeffrey
000022223 Title1 Asia Jeffrey
000022225 Title1 domestic Jones

Any suggestions?
Please explain slowly as am not experienced in vba.

Thanks
P