So we have a .csv file that has
EmplID
Last Name, First Name
Email Address
Total Weeks Worked Previous Pay Period
Total Weeks Worked This Pay Period

I'd like to create a mail merge that only sends the email out to those people when their weeks worked in the previous pay period was LESS THAN this pay period.

Is there an easier way to do this than checking off the boxes in a mail merge.

THANKS FOR ANY ADVISE!