Hello all.
I am Using Excel 2021
So i have a Workbook that has 50-60 Sheets, Each sheet is protected without a password...I need to Email Range D2:K60 as a JPG from the active sheet but try to keep the sizing as is...
if possible in the VBA vertical and horizontal sizing of the picture..
or maybe
Select rows D3:K and double click between columns to keep the size minimal...IDK..
AS the Macro Runs, a combo box that says Do you Want to Email Santa Clause?
if YES...Proceeded Below, but add santaclause@northpole.com as a reciepent..
IF NO...Proceed below..
a Canned Subject of the email :
This is D3 worksheet send "today with todays date and time in mmm/dd/yyyy hh:mm AM/PM" sent via "windows Username".
and a Canned Body of the email..
blah blah, yada, yada...
Here is a Sample of the headers and body:
Thank you all!!
I am Using Excel 2021
So i have a Workbook that has 50-60 Sheets, Each sheet is protected without a password...I need to Email Range D2:K60 as a JPG from the active sheet but try to keep the sizing as is...
if possible in the VBA vertical and horizontal sizing of the picture..
or maybe
Select rows D3:K and double click between columns to keep the size minimal...IDK..
AS the Macro Runs, a combo box that says Do you Want to Email Santa Clause?
if YES...Proceeded Below, but add santaclause@northpole.com as a reciepent..
IF NO...Proceed below..
a Canned Subject of the email :
This is D3 worksheet send "today with todays date and time in mmm/dd/yyyy hh:mm AM/PM" sent via "windows Username".
and a Canned Body of the email..
blah blah, yada, yada...
Here is a Sample of the headers and body:
Thank you all!!