Hi there
I have a sheet called Trade Support with a number of buttons that generates a combination of data sets on a separate sheet called "Summary". Currently I manually go to the summary sheet, copy from cell A1:W76 and paste into an outlook email and sent to the same addressee.
If possible is anyone able to help with creating a command button to open a blank email, create a subject "Today's trades", set as high importance, then paste cells A1:W76 into the body of the email as a picture?
I can provide the 2 tabs as an example if needed
TIA
I have a sheet called Trade Support with a number of buttons that generates a combination of data sets on a separate sheet called "Summary". Currently I manually go to the summary sheet, copy from cell A1:W76 and paste into an outlook email and sent to the same addressee.
If possible is anyone able to help with creating a command button to open a blank email, create a subject "Today's trades", set as high importance, then paste cells A1:W76 into the body of the email as a picture?
I can provide the 2 tabs as an example if needed
TIA