Hi all, i have some code which creates and sends an email from excel but i'm having trouble generating the body text. i believe i need some sort of array but am unsure as i have no experiense with arrays.
i would basically like to go through {K12:K50} and search for critera {<=0.1} .When found count incidents {Incident = incident + 1} and add the values from columns C,D,E,K on incident row to a newline of email body. So the email body test would look like ...
Encountered Incidents = 5
Incident 1 : ColC.Value , ColD.Value , ColE.Value , ColK.Value
Incident 2 : ColC.Value , ColD.Value , ColE.Value , ColK.Value
Incident 3 : ColC.Value , ColD.Value , ColE.Value , ColK.Value
Incident 4 : ColC.Value , ColD.Value , ColE.Value , ColK.Value
Incident 5 : ColC.Value , ColD.Value , ColE.Value , ColK.Value
Any help would be greatly appreciated
Bookmarks