Mail from Excel using VBA

[G.Bregvadze]

HI,

Recently, I was trying to work on the automated Excel worbook, containing some data, and this data must be sent routinely daily to some users.

I was trying to use macro which will copy the defined range in the sheet and sends to the defined recipients with the defined name and so on in the code.

The code already exsist:

Please Login or Register  to view this content.

But the problem is that it sends the whole workbook including only defined range in the sheet.

My request will be if anyone could modify this code in such way that, no attachments will be send to the user, but just the copy-pasted data in to the mail body text area from the defined range of the sheet. the code works fine, but needs this type of modification that I have just described.

Thanks in advance.

[ragavan.sridar1]

if you just want the selected field then try this..

Please Login or Register  to view this content.

End Sub

[G.Bregvadze]

thnaks for the code I will test it now and reply if any issue will be raised, but I have a little question is there a command in VBA to include in the Subject filed of the mail the current date every time I send the mail

[G.Bregvadze]

Also it worns me when I try to use macro: Excpected ENd SUB.

The highlighted command is: Sub Mail_Range()

[G.Bregvadze]

I have corrected the error, I forgot to write END SUB..

So this code sends the email directly from the Excel Worksheet. thanks a lot my dear friend, You helped me a lot.

[ragavan.sridar1]

glad it helped...