ok, so how many rows does your query return?: and please confirm that if that returns 100 rows, you want 100 emails, one per row? is that what you are after? (yeah i know it's probably only one that is 'DOWN' at any one time, but it's still relevant)
SELECT
[FACILITY NAME],
[FAILURE],
[CALL TRACKING NUMBER],
[LANE],
[DATE OPEN],
[TIME OPEN]
FROM [EQUIPMENT].[DBO].[Event Log]
WHERE [Intial Up/Down] = 'DOWN'
AND [UP/DOWN] IS NULL
it looks to me that the results from those six columns could easily exceed 160 characters:
[FACILITY NAME],
[FAILURE],
[CALL TRACKING NUMBER],
[LANE],
[DATE OPEN],
[TIME OPEN]
Lowell