i have written the code in vb.net to generate the automated e-mail, and i m successful to generate the mail and to get the proper data, the only problem is my data which is in Column 's form is not properly aligning, even i use the following query to mention the specifict width fo each column, even in vb.net i use string.PadLeft and string. PadRight function also, it is still not aligning, for your reference i am attaching screen short.
Following query i m applying, see am mentioning proper width for each column
SELECT cast(containerno as char(15)) as Containerno,
cast(cast( DATEDIFF([Day], issuedate, GETDATE()) as char(3)) as int) AS LoadedDays,
)) as char(3)) as POD,
cast(vessel_d as char(15)) as Vessel,
--cast(rem1 as char(16)) as Remarks,
WHERE (eta_d <= GETDATE()) AND (Doc_Copy IS NULL)