How to send an email to from excel using outlook

[ManishAnand]

Hi All,

I am trying to make a macros for sending an email through excel using outlook.

The body of the email should contain ..(The following case has been processed and ready for Quality Check and also picks the case# from Cell "C3" and "D3")

The subject line should say "Case Processed and take the case # from Cell "B2".

It should also show the "To" Field and "CC" too.

Please help me with the VBA code for the above mentioned content.


Thanks a lot.
Manish

 

[VoG]

Take a look here Mail from Excel with Outlook (VBA)

 

[ManishAnand]

Hi,

It is not working.

Could you please provide me some more information?

Thanks,
Manish