RE: Table inside email message. I figured it out!!
Public Sub PrepareMessage() SendEmail Forms!Email_Form_StudentFieldPlacementHours!MsgSubject = "Accumulated Field Placement Hours for " & Fname Forms!Email_Form_StudentFieldPlacementHours!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:
Date
Hours
Comments
" & Week1Date & "
" & HrsWeek1 & _ "
" & Week1Comment & "
" & _ "
" & Week2Date & "
" & HrsWeek2 & "
" & Week2Comment & "
" & _ "
" & Week3Date & "
" & HrsWeek3 & "
" & Week3Comment & "
" & _ "
" & Week4Date & "
" & HrsWeek4 & "
" & Week4Comment & "
" & _ "
Kim Beaul Database Administrator End Sub
All I need now is to indent the table about 1-2 inches.
Kim
Reply from Alex Hedley:
as many times as you need for a single space " " for html or & vbTab for plain text See this Glossary item for others.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.