From: chaitra on
HOW TO SEND CONFIRMATION EMAIL TO USER IN MSACCESS FORM....
IF I CLICK BUTTON EMAIL SHOULD GO TO CUSTOMER....CAN U TELL ME WHERE TO
ENTER ID IN FORM N HOW TO DO THIS TASK
From: Tom van Stiphout on
On Sat, 8 May 2010 05:55:01 -0700, chaitra
<chaitra(a)discussions.microsoft.com> wrote:

In newsgroups using all caps is considered SHOUTING. It won't make you
any friends.
To send an email, create a report with the text you want, and use
DoCmd.SendObject to email it.

-Tom.
Microsoft Access MVP


>HOW TO SEND CONFIRMATION EMAIL TO USER IN MSACCESS FORM....
>IF I CLICK BUTTON EMAIL SHOULD GO TO CUSTOMER....CAN U TELL ME WHERE TO
>ENTER ID IN FORM N HOW TO DO THIS TASK
From: Arvin Meyer [MVP] on
Have a look at this code:

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

It should do the job for you. Just use your form's fields to fill in the
data required to email it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"chaitra" <chaitra(a)discussions.microsoft.com> wrote in message
news:E2B5003C-266A-4842-B049-970BF554FEE5(a)microsoft.com...
> HOW TO SEND CONFIRMATION EMAIL TO USER IN MSACCESS FORM....
> IF I CLICK BUTTON EMAIL SHOULD GO TO CUSTOMER....CAN U TELL ME WHERE TO
> ENTER ID IN FORM N HOW TO DO THIS TASK