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 protected] (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()
        
    SendEmail
    
    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 & ". 

" & _
        "These are the hours that you submitted: 

" & Week1Date & ":   " & Chr(9) & Chr(9) & HrsWeek1 & " hours " & Chr(9) & Chr(9) & Week1Comment & _
        "
" & Week2Date & ":   " & Chr(9) & Chr(9) & HrsWeek2 & " hours " & Chr(9) & Chr(9) & Week2Comment & _
        "
" & Week3Date & ":   " & Chr(9) & Chr(9) & HrsWeek3 & " hours " & Chr(9) & Chr(9) & Week3Comment & _
        "
" & Week4Date & ":   " & Chr(9) & Chr(9) & HrsWeek4 & " hours " & Chr(9) & Chr(9) & Week4Comment
    

 End Sub

Thanks
Kim

---

Reply from Alex Hedley:

Are you comfortable writing HTML?
If you set the message to be HTML and not plain text you can build up a HTML Table
<table> with your tr and td etc