e-mail form

  • Thread starter Thread starter stan
  • Start date Start date
S

stan

hi everybody,
i have a form and subform that records customer order
details...when i have finished entering the order details
i would like to click a buton and email the data on the
form and sub form..is this possible? how do i go about
achieving this?
thanks
 
Yes, this is possible. You can use the SendObject method to send an order
confirmation as an attachment. Or, if you want the confirmation to be in
the body of the email rather than an attachment, you can use Automation to
build the email in Outlook. The links below have information to get you
started:

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209948

MSDN Article with Sample code for creating appointments and emails:
http://tinyurl.com/2knwj

Tony Toews' Access Email FAQ and Links page:
http://www.granite.ab.ca/access/email.htm
 
stan said:
hi everybody,
i have a form and subform that records customer order
details...when i have finished entering the order details
i would like to click a buton and email the data on the
form and sub form..is this possible? how do i go about
achieving this?
thanks
Click to expand...

Perhaps the easiest way is to use SendObject (from Access help):

DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][,
bcc][, subject][, messagetext][, editmessage][, templatefile]

The messagetext argument would be a built-up string:

Dim strMsg As String

strMsg = Me.txtID & vbCrLf
strMsg = strMsg & Me.txtControl2 & vbCrLf
strMsg = strMsg & Me.txtControl3 & vbCrLf
strMsg = strMsg & Me.txtControl4 & vbCrLf
etc.

Then use strMsg as the messagetext argument.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top