insert into macroheader values ('MAIL SEND STATUS','Sends X10 status',0,0,0);
insert into macrodetail values ('MAIL SEND STATUS',1,37,'',NULL,'Check email address',1,'');
insert into macrodetail values ('MAIL SEND STATUS',2,27,'',NULL,'if(pos("[LOCAL1]", "@") <= 0, "The End", "Continue")',0,'');
insert into macrodetail values ('MAIL SEND STATUS',3,26,'',NULL,'Continue',0,'');
insert into macrodetail values ('MAIL SEND STATUS',4,37,'',NULL,'Create Message Body: X10 Stats',1,'');
insert into macrodetail values ('MAIL SEND STATUS',5,15,'[LOCAL2]',NULL,'"----------" + char(13) + char(10)',0,'');
insert into macrodetail values ('MAIL SEND STATUS',6,15,'[LOCAL2]',NULL,'"[LOCAL2]" + "Heat " + if("[X10STATA3]" = "2", "On", "Off") + char(13) + char(10)',0,'');
insert into macrodetail values ('MAIL SEND STATUS',7,15,'[LOCAL2]',NULL,'"[LOCAL2]" + "Fan " + if("[X10STATA5]" = "2", "On", "Off") + char(13) + char(10)',0,'');
insert into macrodetail values ('MAIL SEND STATUS',8,15,'[LOCAL2]',NULL,'"[LOCAL2]" + "Overhead " + if("[X10STATA1]" = "2", "On", "Off") + char(13) + char(10)',0,'');
insert into macrodetail values ('MAIL SEND STATUS',9,15,'[LOCAL2]',NULL,'"[LOCAL2]" + "Couch " + if("[X10STATA2]" = "2", "On", "Off") + char(13) + char(10)',0,'');
insert into macrodetail values ('MAIL SEND STATUS',10,15,'[LOCAL2]',NULL,'"[LOCAL2]" + "Bed1 " + if("[X10STATB1]" = "2", "On", "Off") + char(13) + char(10)',0,'');
insert into macrodetail values ('MAIL SEND STATUS',11,15,'[LOCAL2]',NULL,'"[LOCAL2]" + "Bed2 " + if("[X10STATB2]" = "2", "On", "Off") + char(13) + char(10)',0,'');
insert into macrodetail values ('MAIL SEND STATUS',12,15,'[LOCAL2]',NULL,'"[LOCAL2]" + "Charger " + if("[X10STATB3]" = "2", "On", "Off") + char(13) + char(10)',0,'');
insert into macrodetail values ('MAIL SEND STATUS',13,15,'[LOCAL2]',NULL,'"[LOCAL2]" + "Walk " + if("[X10STATA4]" = "2", "On", "Off") + char(13) + char(10)',0,'');
insert into macrodetail values ('MAIL SEND STATUS',14,37,'',NULL,'Temperatures:',1,'');
insert into macrodetail values ('MAIL SEND STATUS',15,15,'[LOCAL2]',NULL,'"[LOCAL2]" + "----------" + char(13) + char(10)',0,'');
insert into macrodetail values ('MAIL SEND STATUS',16,15,'[LOCAL2]',NULL,'"[LOCAL2]" + "LvngRoom: " + "{G_TEMP_LIVINGRM}" + char(13) + char(10)',0,'');
insert into macrodetail values ('MAIL SEND STATUS',17,15,'[LOCAL2]',NULL,'"[LOCAL2]" + "Outside: " + "{G_TEMP_OUTSIDE}" + char(13) + char(10)',0,'');
insert into macrodetail values ('MAIL SEND STATUS',18,15,'[LOCAL2]',NULL,'"[LOCAL2]" + "Lake: " + "{G_TEMP_LAKE}" + char(13) + char(10)',0,'');
insert into macrodetail values ('MAIL SEND STATUS',19,37,'',NULL,'Send Mail',1,'');
insert into macrodetail values ('MAIL SEND STATUS',20,24,'No TTS',1,'"<"+"[LOCAL1]"+"><"+"[LOCAL2]"+">"',1,'');
insert into macrodetail values ('MAIL SEND STATUS',21,20,'',NULL,'ph_sendsmtpemail("smtp.comcast.net", 25, "powerhome@xxxx.com", "[LOCAL1]", "House", "[LOCAL2]")',0,'');
insert into macrodetail values ('MAIL SEND STATUS',22,26,'',NULL,'The End',0,'');
insert into macrodetail values ('MAIL SEND STATUS',23,24,'No TTS',1,'"Done"',1,'');