470,606 Members | 2,428 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,606 developers. It's quick & easy.

AUTO email with Access

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... :)

Aug 1 '06 #1
3 2742
1,418 Expert 1GB
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
1,418 Expert 1GB
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
1,418 Expert 1GB
Simillar situation in:

Sep 9 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by charlie | last post: by
1 post views Thread by Thomas Leggett | last post: by
1 post views Thread by Laertes | last post: by
1 post views Thread by Craig Addleman | last post: by
13 posts views Thread by S.Dickson | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.