Hello Everyone,
As the title says, I have a very specific printing macro that I would like to try out. Here is exactly what I would like:
In a workbook, on Sheet1 I want to make a button that runs a macro that will print:
Sheet5
Sheet7
Sheet8
Sheet9
Sheet10
Email 1
Email 2
I'm guessing the sheets aren't very hard to write a macro to print out, but is it possible to build the emails in? The emails would be in Outlook but I would like to have them in the workbook so can I either save the email and paste the file name (and then have the macro reference the cell the filename is in) or is it possible to paste the email into excel without losing the formatting and everything?
Also, I will always need to print all of them at least once, but sometimes I will need to print some of them multiple times. So I would like to choose how many of each I print. Is it possible to build something into the macro that chooses how many times you print each part out?
Since the amount of each sheet I need to print on would depend on what is chosen from a dropdown in Sheet1CellA2, is it possible to make some type of "array" macro that bases what it prints off of a dropdown?
I know this is very detailed and is probably a pain if its possible but I would really appreciate the help!
Thank you in advance!
Bookmarks