Thank you,

I have attached a workbook that shows what I have, I deleted all of the personal info and shortened it to around 150 line items but you get the idea.

In the word doc that I want to merge this data to is in my previous post example all I need is "Last Name", "First name", "Rank" and "AA&E" Date to show in the mail merge.

Example of merge in three different areas:

Expired Certifications:
Smith, Jon GM1 1Jan2013
Doe, Joe SB2 5Jan2013
etc

One Month from Expiration:
Smith, Jane BM1 1Feb2013
Dow, Mike SB2 5Feb2013

Two Months from expiration:
Smith, Jon GM1 1JMar2013
Doe, Joe SB2 5Mar2013

Attached Files

Tracker.xlsx (19.0 KB, 28 views)