email the current from a form

  • Thread starter Thread starter dlangdon01
  • Start date Start date
D

dlangdon01

I'm trying to code a command button to open outlook and send the
"current record" to Outlook, either as an attachment or in the body
(doesn't matter which). I do not want to email the form (object) nor
do I want to email an entire report, just the current record opened in
the form. I'm assuming a macro is in order but I'm a little baffled on
where to start.
 
You can always write the contents of the record to a string variable and
then use the docmd.SendObject command with the acSendNoObject option with
the contents of the string variable in the Message part. This requires a
bit of VBA coding but it would do the job.

Rod.
 
Back
Top