Thread: Macro to add two dimensional string array as email body.

Hi
I am trying to automate one of the routine tasks i need to handle. I have a 5 columns with userid, date,time and two flags to indicate two actions performed by user. The sample data looks as below

CJ3 07/01/2012 15:24:19 Y y
CJ3 07/01/2012 14:32:44 Y y
CJ3 09/01/2012 13:47:48 y
CJ3 09/01/2012 07:51:24 Y y
ADR 10/01/2012 15:16:46 Y y
CJ3 11/01/2012 22:25:24
CJ3 11/01/2012 19:15:33 Y y
CJ3 11/01/2012 14:26:10 Y
ADR 11/01/2012 11:24:15
CJ3 11/01/2012 09:41:44 Y
CJ3 11/01/2012 08:55:18 Y
ADR 12/01/2012 17:46:10 Y y
ADR 12/01/2012 11:34:04 Y y
CJ3 12/01/2012 09:17:01 Y
PC6 13/01/2012 15:55:46 y
ADR 13/01/2012 14:35:50 Y
MO5 13/01/2012 09:37:22 y
CJ3 13/01/2012 04:47:31 Y

For each user, I need to identify, if either or both of the flags are missing, if so I need to send one consolidated email with the date, time and a message indicating what flags are missing and send out a email.

Currently, I have written code to create a string array to hold these three columns, but i am not aware how to make this string array as body of the email.

Thanks in advance for your help.

upload a sample workbook, with your code included. I assume you have a sheet/table of user ID & email address for each to map users to email addresses to send to.

Thanks snb, this has resolved my error.