automated email

[tk]

Hello,
At the moment im building a database for a driving school, I have a
customer field, with email address as an attribute. I dont know much
about macros in access but once the customer has booked a lesson i
want a automated email to be sent to the customer 3 days or a few days
before their driving lesson, stating the driving instructor, booking
ID time and date etc.
I have 5 tables apart from customer: Employee, Car, Booking, Package
and Session therefore the email will have to take out data from the
session table for the following data booking ID, drving instructor ID,
session date and time
can someone please help figure out or tell me the code?
Thank you!

[Mark1234567]

You might want to just use Task Manager 2007 from www.orbisoft.com. It
has email reminders in and I think it can handle all that other stuff
too. It's made with MSAccess and it's a free download for single
users. The email messages it sends can be customized and sent to a
variety of people.

In the user-defined field section of the email reminder help topic,
you'll see you can enter a customer's email for an email reminder:

Recipient
---------------

Select the person(s) to receive the email reminder for the selected
Rule. Enter new Recipients in the new record row (indicated by the
asterisk * indicator).

There are four different types of Recipients that can be entered here:

Raw email addresses
-------------------------------

Enter the email address of the Recipient, e.g.
an*******@anydo main.com.

Address book names
--------------------------------

Enter names of people that exist in the relevant email program's
address book, e.g. Frank Brown.

Dynamic team members
------------------------------------

Enclosed in { } brackets, these values change for each task. For
example, {Allocated To} gives the email address for the team member
each task is allocated to.

User-defined field values
-----------------------------------

The value of a user-defined field for a task will be used here as an
email address. For example, you may decide to have

1. A user-defined task field named Customer Email.
2. A Quick Entry Template based on a Task Name that stores the email
address of a customer (if the Task Name is used as the customer name).
3. A user-defined field named Status that has the lookup values
Started, Awaiting Info, Reviewed, and Sent used as drop-down list
items.
4. An email reminder rule called Status: Started, with the Where
property set to [Status]='Started', and similar Rules copied for the
other Status values.

Using points 1 To 4 above, a customer would be emailed every time the
status of their task/job changes.

Tip: Another way of accounting for task status changes is to have a
Rule with the Where property set to [LastUpdated]=Date().

--------------

In your case the Criteria property would be [Deadline Date]<=Date()+3

In Task Manager 2007 you can have user-defined fields with drop-down
values to store things like "Car" and "Place". See
http://www.orbisoft.com/kb/taskmanager/2007/q/1120.htm.

You can also keep group all driving "Session"s to a particular
customer. See:

Q: How do I have a main project with many sub-projects?
http://www.orbisoft.com/products/tas...m#QMainProject

Regards
Mark
On Apr 3, 4:30 am, "tk" <deviousdevi... @gmail.comwrote :

Hello,
At the moment im building a database for a driving school, I have a
customer field, withemailaddres s as an attribute. I dont know much
about macros in access but once the customer has booked a lesson i
want aautomatedemail to be sent to the customer 3 days or a few days
before their driving lesson, stating the driving instructor, booking
ID time and date etc.
I have 5 tables apart from customer: Employee, Car, Booking, Package
and Session therefore theemailwill have to take out data from the
session table for the following data booking ID, drving instructor ID,
session date and time
can someone please help figure out or tell me the code?
Thank you!

[Arvin Meyer]

You can send an email by using SendObject:

Private Sub cmdEmail_Click( )
On Error GoTo Err_cmdEmail_Cl ick

Dim strDocName As String
Dim strEmail As String
Dim strMailSubject As String
Dim strMsg As String

strDocName = Me.lstRpt
strEmail = Me.txtSelected & vbNullString
strMailSubject = Me.txtMailSubje ct & vbNullString
strMsg = Me.txtMsg & vbNullString & vbCrLf & vbCrLf & "Your Name" & _
vbCrLf & "MailTo:yo***** **@nowhere.com"

DoCmd.SendObjec t objecttype:=acS endReport, _
ObjectName:=str DocName, outputformat:=a cFormatHTML, _
To:=strEmail, Subject:=strMai lSubject, MessageText:=st rMsg

Exit_cmdEmail_C lick:
Exit Sub

Err_cmdEmail_Cl ick:
MsgBox Err.Description
Resume Exit_cmdEmail_C lick

End Sub

Have a look at my sample database at:

http://www.datastrat.com/Download/Birthday2K.zip

for a sample of tickler code.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"tk" <de************ @gmail.comwrote in message
news:11******** **************@ e65g2000hsc.goo glegroups.com.. .

Hello,
At the moment im building a database for a driving school, I have a
customer field, with email address as an attribute. I dont know much
about macros in access but once the customer has booked a lesson i
want a automated email to be sent to the customer 3 days or a few days
before their driving lesson, stating the driving instructor, booking
ID time and date etc.
I have 5 tables apart from customer: Employee, Car, Booking, Package
and Session therefore the email will have to take out data from the
session table for the following data booking ID, drving instructor ID,
session date and time
can someone please help figure out or tell me the code?
Thank you!