Re: Sending Email Message from Access 2003
- From: "Arvin Meyer [MVP]" <a@xxxxx>
- Date: Fri, 4 Jul 2008 22:12:20 -0400
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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
"GL" <GL@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1C027770-118E-449E-BBAA-8740EAC5454E@xxxxxxxxxxxxxxxx
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
.
- Prev by Date: Re: Autonumber - with text
- Next by Date: Get volume serial error shows error.
- Previous by thread: Re: Autonumber - with text
- Next by thread: Get volume serial error shows error.
- Index(es):
Relevant Pages
|
