Sending Email Message from Access 2003

  • Thread starter Thread starter GL
  • Start date Start date
G

GL

Hi,
Hoping someone out there can help. I've used access for quite a while, but
have gotten away with not doing too much coding or just copying chunks of
what I need, its a weak spot of mine! I have a form/subform that has action
items and responses. When someone posts a response to an action item I need
the system to send an email, with some of the basic data from the form. I
tried using a macro, but couldn't get it to look up the persons email address
in a table, as the email needs to be sent to whoever initiated the action
item - but the email address can be on the form, so is able to be referenced
from the action item form. Any advice would be VERY appreciated!!! If
coding is the way I need to go, please be as specific as possible. THANKS!!
GL
 
If you're using Outlook, try the code at:

http://www.datastrat.com/Code/OutlookEmail.txt

You can also use SendObject, especially if you don't use Outlook:

DoCmd.SendObject acReport, "ReportName", acFormatTXT, "email address", , ,
"subject", , False

instead of email address, use the form reference:

Me.txtEmailAddress

or whatever your textbox holding the email address contains.
 
Back
Top