Steve 1962
Active Member
- Joined
- Jan 3, 2006
- Messages
- 346
- Office Version
- 365
- Platform
- Windows
Hi
I put together an Excel report each morning that takes up one worksheet (about 55 rows & 26 columns). Once compiled, I have to email it out to a distribution list.
Is there some way (may code based) that I can have a button on that worksheet that I activate that then automatically places that worksheet (not the workbook) into a blank Outlook email (doesn't need functionality, even a screenshot would do) with the distribution list already populated in the "To" field. Just a further addition - also place a title into the "Subject" field.
Thanks
Steve
I put together an Excel report each morning that takes up one worksheet (about 55 rows & 26 columns). Once compiled, I have to email it out to a distribution list.
Is there some way (may code based) that I can have a button on that worksheet that I activate that then automatically places that worksheet (not the workbook) into a blank Outlook email (doesn't need functionality, even a screenshot would do) with the distribution list already populated in the "To" field. Just a further addition - also place a title into the "Subject" field.
Thanks
Steve
