Excel - Outlook Connection

Steve 1962

Active Member
Joined
Jan 3, 2006
Messages
259
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
 

Forum statistics

Threads
1,082,585
Messages
5,366,466
Members
400,892
Latest member
lamarh755

Some videos you may like

This Week's Hot Topics

Top