Is there a way to insert a table into the body of the email message? Right now my message looks like: Dear Laura
To date you have completed 46 hours for your field placement at SAM Program (East Site). By the end of the week of Feb 1 - 7 64 hours should have been completed. If you are short of hours or have any questions regarding your hours please contact your Field Placement Specialist Julie Pollock email@example.com (905) 575-1212 Ext. 2033.
These are the hours that you submitted:
Jan 11 - 17: 12 hours Jan 18 -24: 8 hours Jan 25 - 31: 12 hours Feb 1 - 7: 14 hours
My boss would like the lower portion to be in a table.
My code is:
Public Sub PrepareMessage()
Forms!Email_Form_StudentFieldPlacementHours_HTML!MsgSubject = "Accumulated Field Placement Hours for " & Fname Forms!Email_Form_StudentFieldPlacementHours_HTML!MsgBody = "Dear " & Fname & "
To date you have completed " & TotalHours & " hours for your field placement at " & Agency & ". By the " & _ "end of the week of " & Week4Date & " " & ExpectedHours & " hours should have been completed. _ If you are short of hours or have any questions regarding your hours please contact your Field Placement Specialist " & FPSName & _ " " & FPSE & " " & FPSPhone & ".