VBA code to Email excel sheets as an attachment to different people

seeker123

Board Regular
Joined
Oct 8, 2011
Messages
81
Hi everyone

I have an excel file with several sheets and i want to send every sheet as an attachment to certain people in to and cc in outlook .recipients are different for every sheet and I want to add subject and body of email too.( I want email to be ready with To CC Subject and body and just press send .) can you help me?

thanks a lot in advance.
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Watch MrExcel Video

Forum statistics

Threads
1,099,472
Messages
5,468,823
Members
406,611
Latest member
hanman453

This Week's Hot Topics

Top