Alteration in VBA for Sending Email automatically

Hi all,

I have attached two excel files. Files are "Send Mail via Outlook" and "Send Mail".

File "Send Mail via Outlook" has macro which sends active workbook via email automatically through outlook. On clicking button in the sheet, a userform opens for entering email ID to whom it has to sent and there by active workbook goes.

I have attached another file "Send Mail" which doesnot have macro, but it has extra tab between Home Tab and Insert Tab which is called "Email" which inturn contains another button "SendMail".

The code from ""Send Mail via Outlook" has to be copied and pasted in file "Send Mail" to perform same function.

The 1st macro name should be "Sub SendMail()", on running this macro all the process should complete.

Thanks in advance..

Hi all,

I got the solution in other forum..