I have a report that gets filtered by name to show what assignments that person has. Right now I pick the name and run the report. I then email the report to the person. I would like to automate this process by letting access see if that person has an an assignment and if they do run the report and attach it to an email with that persons email filled in and then repeat for all remaining names. I am sure it is possible but I'm only a beginner. Any help would be appreciated.