VBA Macro to send an email through Outlook with column information and if formula

[gabo137]

Hello,

I am new in the site and wanted to ask for your help. I want to make a Macro to send an email through Outlook with the rows information of an Excel table that has the date of "today", and with certain cells information. All of this with a button that says Daily Report, so the user can click on it and send the email directly.

For example, if I have 10 rows and only 2 of them have the date of "today" in the a specific column, send an email with the information of the columns 1, 2, 5 and 6 of those rows.

Thanks in advance for your help!

[Logit]

.
https://www.rondebruin.nl/win/s1/outlook/mail.htm

[gabo137]

Thank you! I will check the info of the link.