Macro to create an outlook email with contents of various cells?

Hi all,

Trying to create a macro to create an outlook email using VBA. The email contents will be from a worksheet.

The title will be from cell F6, and the body contents will be from cells K19, K20, and K21.

I'm not familiar with how to do this, and would appreciate some help please.

Hi
try this
you will need to have the outlook object library checked under tools > references in the VBA area for it to work

Please Login or Register  to view this content.