Send mail with bullet points if cells within range is not empty

Hi Forum,

I have to send a daily status mail and therefore i need some help to make a VBA that checks if cells within a range is empty or not. If not then enter data as a listed items in a mail.

I've attached the sheet from where i want the data to be collected and a photo of an example of how the data should be presented in a mail.

https://imgur.com/a/65i6ij2

Can someone help me?

Thank you in advance.

With outlook:

Please Login or Register  to view this content.