If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
generate a confirmation email
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 -- deb |
#2
|
|||
|
|||
generate a confirmation email
woo hoo - i'll answer my own question
just add a SendObject line to the existing save macro nifty -- deb "deb" wrote: 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 -- deb |
#3
|
|||
|
|||
generate a confirmation email
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 , , , ", , , "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. |
Thread Tools | |
Display Modes | |
|
|