How to send email with attachments

[Gaurang Mhatre]

Hi Friends,

Need help in creating macro..
How to send emails with help of macro by attaching files keeping people in cc.

Please find attached excel for your reference.

Thanks for your help in advance.

Regards,
Gaurang Mhatre

 

[Afarag]

@Gaurang Mhatre

you have to get what you looking for from the below link
the best reference in any issue related to mail from Excel
just edit the code with your cell reference
http://www.rondebruin.nl/win/s1/outlook/mail.htm

Gratefully,

 

[Gaurang Mhatre]

Thanks Afarag..will get back to you if i have queries.

Regards,
Gaurang