A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

generate a confirmation email



 
 
Thread Tools Display Modes
  #1  
Old April 16th, 2010, 12:53 AM posted to microsoft.public.access.forms
deb
external usenet poster
 
Posts: 898
Default 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  
Old April 16th, 2010, 01:07 AM posted to microsoft.public.access.forms
deb
external usenet poster
 
Posts: 898
Default 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  
Old April 16th, 2010, 03:42 PM posted to microsoft.public.access.forms
ghetto_banjo
external usenet poster
 
Posts: 325
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.