Yes basically, I like to be able to send each individual an email with an attached PDF file. As shown in report.jpg, force new page is set on an ID header, when I do a print preview, only each person's report are display on the screen. Now I just need to figure out how to send it via email.

2. objMail.Body = "This is the email body" 'Replace it by your email body
3. objMail.Subject = "This is the email subject" 'Replace it by the email subject

There is also a form in the database, with a button. Once you click the button, the emails will be sent, using the default email account in your Outlook.
Currently it works with Outlook 2013 and Access 2013. In order to get it to work with Office 2010, you can simply import all the form and the Visual Basic module into your database, open the module in the Visual Basic Editor, open the Tools->References menu, and uncheck the reference to the Microsoft Outlook 15 Object Library. You will then need to scroll the list down and check a reference to the Microsoft Outlook 14 Object Library.

This should get it working. The code uses a table name instructor table, which I believe is the name of the table that contains the email addresses you want to use.

As an alternative, you can create a new module yourself, with the code for the procedure I have posted here. You will need to add references to the Microsoft Outlook 14 Object Library and to the Microsoft ActiveX Data Objects 2.x Library (I did it for 2.8 library version).
Once you do this, you can run the code, the best way being similar to the way I used with the form in the database attached.

OK that works, how do I send just correct portion of the report to each person? The instructor1.pdf include all the pages in one file, that mean everyone the the same file with everybody else's information on it. Its there a way to send just the pages for that person? Example: if Larry only has two pages, how do I send him just that two pages out of said 90 pages. On the report if a "force new pages before section" is added to the ID header, then on the print preview, it will display the report by each person's ID not as one continues report as with instructor1.pdf.