To whom it may concern:

We are beating our heads up against a wall with a Next Record If Rule in a mail merge. We have a set of data that is in an Access Table for example that has a person's name and User ID but, then each person has multiple permissions associated with their User ID and name. We need a next record if rule that states if they have another permission associated with their User ID and name to insert the next permission. We are trying to get feedback from all of these users via email to see if they still need that permission to that file or system anymore.

Attached is an example and also due to this being PII information I have taken out their names and User IDs placed fakes ones in its place. Also, our data set is very large and has over 500 people in it that is why we are trying to automate the mail merge.

Thanks a million to whomever can assist us.

Attached Files

NextRecordIfmailmerge.xlsx (14.3 KB, 32 views)