How can i format .HTMLBody message into tables. I know i need to use <table></table> html tags but i'm not sure how.
e.g
---------------------------------------------------------------
|Fields Changes | Project Address |On Hold |
---------------------------------------------------------------
|strControlName | strProjectAddress |strApproveStatus|
---------------------------------------------------------------
Code runs in Access2010
e.g
---------------------------------------------------------------
|Fields Changes | Project Address |On Hold |
---------------------------------------------------------------
|strControlName | strProjectAddress |strApproveStatus|
---------------------------------------------------------------
Code:
.HTMLBody = "<HTML><BODY STYLE=font-size: 16pt; font-family: Calibri>" _
& "<b>Fields Changed: </b>" & " " & strControlName & "<br><br>" _
& "<b>Project Address: </b>" & " " & strProjectAddress & " " & ProjectBorough & "<br><br>" _
& "<b>On Hold: </b>" & strApproveStatus & "<br>" _
& "<b>Project #: </b>" & ProjectNum & "<br>" _
& "<b>Apptoved/Rejected: </b>" & TaskStatus & "<br>" _
& "<b>Field Staff: </b>" & FieldManager & "<br>" _
& "<b>Assign Date: </b>" & AssignDate & "<br>" _
& "<b>Next Expected Action Date: </b>" & NEAD & "<br>" _
& "<b>Task: </b>" & TaskDesc & "<br>" _
& "<b>Task Description: </b>" & TaskDescExt & "<br>" _
& "<b>Application #: </b>" & AppNum & "<br>" _
& "<b>Submission Date: </b>" & SubmissionDate & "<br>" _
& "<b>Agency: </b>" & Agency & "<br>" _
& "<b>Agency Office: </b>" & AgencyOffice & "<br>" _
& "<b>Task Note: </b>" & TaskNote & "<br>" _
& "<b>Note To John: </b>" & JohnMemo & "<br>" _
& "<b>Status: </b>" & strStatus & "<br></BODY></HTML>"
Code runs in Access2010