T
twsrxdfcgvhjbngj
Private Sub Image15_Click()
DoCmd.SendObject acReport, "rpt_All_Lim_Du_30_DAYS_Unit",
"SnapshotFormat(*.snp)", "", "", "", "ALL LIMITED DUTY EXPIRES IN 30 DAYS",
"Good Afternoon AdminChfs," & Chr$(13) & _
"Attached is the Limited Duty (LimDu) roster for MCAS Cherry Point." &
Chr$(13) & _
"It consist of multiple pages, so please scroll to your unit's page and
review for accuracy. All Marines expiration dates highlighted in red limited
duty period has expired and requires immediate attention. Please ensure those
Marines stop by to see" & Chr$(13) & _
"Ms. Mallette as soon as possible. She is located at the Naval Hospital on
the first floor and her ext: is 466-0135. Again, these LimDu periods has
expired and should have been taken care of by now. All Marines in a LimDu
status should contact" & Chr$(13) & _
"Ms. Mallette 60 days prior to their LimDu expiration date. This will ensure
that they are assigned to another period of LimDu prior to the first one
expiring, returned to full duty on-time, or submitted for a PEB. Please don't
hesitate to call if" & Chr$(13) & _
"I can be of further assistance to you in this matter. Also, could you
indicate something similar on the 30, 60, and 90 day rosters please. Thanks
in advance." & Chr$(13) & _
"LCpl H ", True, ""
End Sub
How do I put a gap between the greeting and the rest of an email so it reads:
Good Afternoon AdminChfs,
<-- How do I get this space
rest of message
Ive tried everything but I keep getting the same error "Compiled error: end
of expression". I didnt write this code and I am fairly new to access so any
help would be greatly appreciated. Thanks
DoCmd.SendObject acReport, "rpt_All_Lim_Du_30_DAYS_Unit",
"SnapshotFormat(*.snp)", "", "", "", "ALL LIMITED DUTY EXPIRES IN 30 DAYS",
"Good Afternoon AdminChfs," & Chr$(13) & _
"Attached is the Limited Duty (LimDu) roster for MCAS Cherry Point." &
Chr$(13) & _
"It consist of multiple pages, so please scroll to your unit's page and
review for accuracy. All Marines expiration dates highlighted in red limited
duty period has expired and requires immediate attention. Please ensure those
Marines stop by to see" & Chr$(13) & _
"Ms. Mallette as soon as possible. She is located at the Naval Hospital on
the first floor and her ext: is 466-0135. Again, these LimDu periods has
expired and should have been taken care of by now. All Marines in a LimDu
status should contact" & Chr$(13) & _
"Ms. Mallette 60 days prior to their LimDu expiration date. This will ensure
that they are assigned to another period of LimDu prior to the first one
expiring, returned to full duty on-time, or submitted for a PEB. Please don't
hesitate to call if" & Chr$(13) & _
"I can be of further assistance to you in this matter. Also, could you
indicate something similar on the 30, 60, and 90 day rosters please. Thanks
in advance." & Chr$(13) & _
"LCpl H ", True, ""
End Sub
How do I put a gap between the greeting and the rest of an email so it reads:
Good Afternoon AdminChfs,
<-- How do I get this space
rest of message
Ive tried everything but I keep getting the same error "Compiled error: end
of expression". I didnt write this code and I am fairly new to access so any
help would be greatly appreciated. Thanks