Send Email Vba With Attachment. If you want to keep someone in cc write his her email id in the cc column. This vba macro code with add the entire activeworkbook as an attachment to a brand new outlook message.
This vba macro code with add the entire activeworkbook as an attachment to a brand new outlook message. Now to send emails to each email id in column follow these steps. Create email message with activeworkbook attached.
Here we are sending mail to multiple recipients and also attaching a file from local drive we have also added the text for body in the mail.
This vba macro code with add the entire activeworkbook as an attachment to a brand new outlook message. Massage in massage body column. Run the above code and it will send the email with the mentioned body of the email with the current workbook as the attachment. Use the below vba code to send emails from your outlook.