Create PDF for Each Sheet and Then Email Each Sheet

I have been working with various solutions out there but to no avail, and would really appreciate some help on this.

I basically have one master workbook, that I will need to (1) breakup into smaller worksheets, (2) save each worksheet out as a PDF file, and (3) email the PDF as well.


I have solved for the first two parts, however
I have two disparate macros that each seem to accomplish one part of each of the tasks, but cannot get them to work together.

So I already have:
a) a Macro that will break a mastersheet down into smaller sheets, create PDF files with respect to each newly created sheet (based on values in some Column, A, for example), and name/save the resulting PDF files accordingly to a path of my choosing
b) a Macro that will break a mastersheet down into smaller sheets, and email out each sheet as an Excel file <-- I need this to be a PDF file, not Excel

Again, I'm not sure how to create a macro that will accomplish both of the above, but retain everything in PDF format (as explained in the 2nd line of my post above).


As for the emails themselves:
(as outlined in step b. above), the macro code I do have allows me to specify cells that will house the email addresses, for example (on each sheet, in cell J2), as well as the subject for each email, which can again be tailored to each sheet (based on some dynamic reference).
The macro I have also allows for CC and BCC email addresses (so they could be on each sheet in cells J3 and/or J4 for example)
I can generate these for each worksheet, but just wanted to throw this out there.


I would really appreciate any help offered on this.
Attached is a sample workbook if it helps.


Thanks in advance!

FYI:
The macro that I'm using for Part a) above came from here: http://www.franklinharper.com/2011/0...cel-worksheet/
The macro that I'm using for Part b) above came from here: http://www.rondebruin.nl/win/s1/outlook/amail5.htm

Hi hamdixa

Attach a File, with existing Code, that shows how you get from here

a) a Macro that will break a mastersheet down into smaller sheets, create PDF files with respect to each newly created sheet (based on values in some Column, A, for example), and name/save the resulting PDF files accordingly to a path of my choosing
b) a Macro that will break a mastersheet down into smaller sheets, and email out each sheet as an Excel file

and we'll show you how to get to here

a Macro that will break a mastersheet down into smaller sheets, and email out each sheet as an Excel file <-- I need this to be a PDF file, not Excel

Hi hamdixa

I'll need to get back to you after the Holiday weekend...have Family in. Sorry...

Hi hamdixa

The Code in the attached appears to do as you require. As you have links that I haven't access to, for testing purposes, I've place the Email Address in Cell Q2 below the File Name. You can change that if you wish.

The Code takes a bit of time to complete due to Page Setup and PDF Creation.

Let me know of issues.

You're welcome...glad I could help. Thanks for the Rep.