Hi, I'm trying to email a workbook to a list of users with subject and the body message. The SendMail method would work, but it doesn't have allow to enter a email Body. Could you help me with the code to do the following:
a) Add a body of message while using SendMail
or
b) Send an email with:
Code
Attachment = ActiveWorkbook
Subject = Range("A1").Value
Message = Range("A2").Value
Recipient's email = Range("A3").Value
Thank you