squidlings
asked on
Email Current Record Access 2007 VB Issue
Hi,
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
Thanks,
Rich
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
Thanks,
Rich
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome :)
ASKER
Rich