SQLTeam.com | Weblogs | Forums

How to get gridlines in HTML results on email

I am trying to insert grid lines in the html results which populates to email from a stored procedure. I have the following in the SET @eBody. I tried a number of different ways to make use of the border collapse:collapse tag but it's not working. Any help please?

This is what it looks like at the moment and it populates a border around the all the columns but no grid lines. (I've taken out the border collapse tag)

SET @eBODY = '<table border="1" font size="2" face="Calibri"><table><tr><td><b>FundCode</b></td><td><b>Rule_No</b></td></tr>'