February 12, 2014

Using excel VBA code How to send email and attachment


Using excel VBA code How to send email and attachment.

Requirements:

1. Microsoft office Excel & Excel VBA
2. Microsoft Outlook

Description

I am going to draft an email with attachment using excel. first we need to mention To email ID, CC(if required), email Subject and attachment path in excel sheet and then copy below coding in VBA coding area then execute the code it will generate the email draft