How to set custom print area for multiple pages?

Hi Everyone,

With the help of this forum I have a macro that converts every sheet in my workbook to individual PDF's, and then emails them to me. This has worked out great so far, with the exception of the sheets that require 2 or more pages due to the size of them. I'm trying to figure out how I can set up a custom print area, so that I can choose exactly which cells will show up on page 1, and which ones will show up on page 2 (and page 3, etc..). At the moment though, I have been unable to add any page breaks that would mark where page 2 should start, which causes the PDF to be a single page of unreadable data since there's so many cells included in one page (everything is too small to read). Can you all help me figure out how to set up these custom print areas? Here's the things I've tried so far:
- Inserting "Page Break" appears to do absolutely nothing no matter where I try to insert it.
- Dragging the page break in the "page break view" to my desired cutoff point for page 1. When I do this, the rest of the sheet is simply omitted from the PDF entirely.

I've attached some photos to explain -

Page Break 1: Shows the entire sheet as a single page on the print area
Page Break 2: The red line is where I want Page 2 to start
Page Break 3: What happens when I try simply dragging the page break to where I want page 2 to start. It doesn't appear that a "page 2" is automatically added for me.