I need a macro when engaged to do two main functions.

1st i need it to email either a specified range of rows and columns like a4:d8 or, to not require me to unhide my already hidden rows and columns when emailing.

2nd, i have a list of email addresses in column f (for example f5:f10 but maybe more if i add more email recipients) of who i would like the email to be sent to.

i need the macro to work together and email what i need specifically and then read my list of email recipients and email the list all while hitting one button.

Any help would be great, thank you!