generate a confirmation email

  • Thread starter Thread starter deb
  • Start date Start date
D

deb

how do i put a command on a button to generate a confirmation email when a
new client is created

so at the end of the form i already have a button that saves and prints but
i want it to send an email to the accounts manager with the form details as
well
 
woo hoo - i'll answer my own question

just add a SendObject line to the existing save macro

nifty
 
you can use the SendObject command to create an email, and you don't
even need to attach an "object" to it if you don't want to.

Full syntax:
DoCmd.SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc,
Subject, MessageText, EditMessage, TemplateFile)


If you dont want an attachment:

Docmd.SendObject , , , "(e-mail address removed)", , , "subject line",
"blah blah blah", true



EditMessage = true, means that the email comes up to be edited first.
If this is false and you want to send it automatically, Outlook will
give a warning everytime that another program is trying to take
control of sending emails.
 
Back
Top