I would like to know if it is possible to e-mail fields from the current record only.
I'm writing a holiday calendar. Once the user enters the start and end date, I want to e-mail this to their manager to authorise. I don't want to attach a report, just use the dates the user has just entered.
The below is garbage I've written...sorry I know I'm bad...
Dim strMsgBody As String
strMsgBody = " Please Authorise the holiday dates," & [Table].[StartDate] & "to " & [Table].[EndDate]
DoCmd.SendObject acSendNoObject, , , , , , , strMsgBody