AUTO email with Access

jaytrader

I need Access to automaically email the contacts data in TXT Format like this,

First_Name: John
Last_Name: Smith
Address: 12345 TBD

When a particular Cells data is = -1 then I need to send that contacts data as an E-mail TEXT with the labels not as a TEXT FILE attatchment but as TEXT in the email body...

BTW the table needs to be auto updated about every 5-10 minutes....to update the data...

then when a particular cell is = -1 then that triggers the email event...and sends the contacts data...

I need as much code hand holding as possible...Very new... :)

THX

Aug 1 '06 #1

PEB

So you need a code/ function for generating the txt file...

For sending the email there is one command that yo c use in Ms Access and I don't think that it is a problem

For your generation code see this exemple and commands inside:

Width # Statement Example
This example uses the Width # statement to set the output line width for a file.

Open "TESTFILE" For Output As #1 ' Open file for output.
Print #1, "Name: " , Forms!Myform!Name
Print #1, "Position: " , Forms!Myform!Position
Close #1 ' Close file.


Those exemple is taken from Access Basic help! All the commands are described there!

Have a nice day!

Sep 9 '06 #2

PEB

And if this information have to be like a Body so why do you want to generate your TXT File you don't need to do it!

Sep 9 '06 #3

PEB

Simillar situation in:

http://www.thescripts.com/forum/thread533046.html

Sep 9 '06 #4