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
|