Hi Everyone,

I am new to the world of Macros. I am trying to accomplish a task where I need to email the excel file I am working on to another person using outlook. When I run the macro it should open an outlook compose message with the file as an attachment and a pre designated email addresses (three in total) two in the email TO and one in CC.

Subject of the email should begin with some pre defined text. the mail should not be sent, the macro should stop at opening the compose message with above attributes so that the user can insert custom text in the mail and send it themselves.

Email addresses should be picked up from Cells A 10, A11(in email TO) and A 13(CC)

Hope I managed to articulate my problem well.

Thanks in advance for your help. Much appreciated. Please let me know if any clarification is needed.

Regards,
Ck