Send data table from Excel to outlook as Email

Hello friends,

I wish to be able to send an entire table of contents (typically names and numbers as listed below), copied and sent via email along with a subject and salutation in the email:


Login ID Capacity Resolved Variance Hours CPH
alai 24 2 -22 2 1
domid 0 0 0 0 0
harng 28 11 -17 4 2.75
kal 28 8 -20 3 2.67
kouh 28 2 -26 2 1
karav 0 0 0 0 0
karia 28 7 -21 5 1.4
mahud 0 0 0 0 0
nidis 24 23 -1 8 2.88
nidk 28 20 -8 7 2.86
akrig 28 12 -16 5 2.4
rak 24 20 -4 7 2.86
rathik 28 18 -10 7 2.57
rik 0 0 0 0 0
rnaaz 28 39 11 6 6.5
su 28 11 -17 5 2.2
shat 28 9 -19 5 1.8
smat 0 0 0 0 0
tmise 28 18 -10 7 2.57
sar 0 0 0 0 0
viy 0 0 0 0 0
TOTAL 380 200 -180 73 2.74

Typically the email content would be "Hello xxxxx, our team contacts for the hour"

subject would be "contacts"

I was wondering if I could somehow automate the excel sheet to send out the mail every hour or 3 hours as such, by the click of a button or after entering a value in one of the cells.

Any help would be greatly appreciated.

Thank you

Thanks Xlrator

However I could not understand a single of what was there. Basically I am not good with the code whatsoever.

Is there a way we can trigger an email based on a certain threshold value in one of the cells.

Ex: for every time cell K5 goes below or above 5 an email is triggered. like a warning mail.

Thank you very much once again for looking into this.