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
squidlingsAsked:
Who is Participating?
 
mbizupConnect With a Mentor Commented:
<< I would like to know if it is possible to e-mail fields from the current record only. >>

Do you mean start and end dates as displayed in the record the user is currently seeing on a form?


strMsgBody = " Please Authorise the holiday date: " & Me.[StartDate] & " to " & Me.[EndDate]

' Youll have to fill in more of this line... email addresses, etc
DoCmd.SendObject acSendNoObject, , , , , , , strMsgBody

Open in new window

0
 
squidlingsAuthor Commented:
Perfecto!!!  Easy as that... Massive thanks.

Rich
0
 
mbizupCommented:
You're welcome :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.