CODE for Sending active sheet as body of the email

columbus

New Member
Joined
Jan 9, 2019
Messages
1
Hi,
Good Day guys!
I need help on the code for sending an email (item.display instead of item.send). I want to have the TO CC and Subject ("Portfolio Dashboard Red and Yellow Report" + a prior specific date included (ex. Portfolio Dashboard Red and Yellow Report 27-2-2019) reflected as well. basically, the body of the email, contains the the information in a worksheet and a screenshot in the worksheet.

Thanks in advance -
Columbus
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Watch MrExcel Video

Forum statistics

Threads
1,109,518
Messages
5,529,308
Members
409,862
Latest member
lbisacca
Top