VBA Macro copying and emailing report from excel content

[ALLANT]

Hello Forum Guru/expert,

I have a daily report to send email from excel files- attached excel file for reference with desired result. I would like to generate email on an excel spreadsheet that will copy worksheet contents to an email body. Im a newbie to macro and I have no idea how to code.

Appreciate your help on this..

Thanks Allan

[dotchiejack]

attached excel file for reference

I don't see a file.

[ALLANT]

Ooops sory, i forgot the attachments.. See attached. Thanks

[dotchiejack]

will copy worksheet contents to an email body

Does it have to be in the body, not as a attachment?

[ALLANT]

Yes excel content should be in the body of email and not an attachment. thanks

[dotchiejack]

Hi,
This an example that works with outlook.
Push button MAIL, select the addresses you want to mail to and Push the button SEND.
Hotmail will open and dispaly the mail. If you want you can change Display to Send in the code. (Sent in the code is green) than the mail will be sent once you open Outlook.
See attached

[ALLANT]

Hello dotchiejack, I tried many times but still no luck.. Can you check again? Thanks

[dotchiejack]

Is your workbook macro enabled?