View Single Post
 
Old 02-24-2017, 08:22 AM
RHensley RHensley is offline Windows 8 Office 2013
Novice
 
Join Date: Feb 2017
Location: Baltimore, MD
Posts: 10
RHensley is on a distinguished road
Default Mail Merge Next Record If rule

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
File Type: xlsx NextRecordIfmailmerge.xlsx (14.3 KB, 32 views)
Reply With Quote