Automatic Create Message - Microsolf Access

[qiqinuinaifen128]

Dear Pros,

I have a question about Microsoft Access.
Currently i have a simple Access datebase for my client. The database contain all my customer particulars. Every time if thare is new customer in, i has to send a SMS to my client. Below is the template of my SMS.

CONFIRMATION
Instructor: Richard Lee 123456789
1st lesson on 2 Jan and every Friday 4.30pm @ ABC Swimming Complex.
Fee: $50 per month per student
You may make your first payment by bank/internet transfer to UOB current 123-456-789 or DBS Current 123-456-789 within 3 days to confirm your slot. Kindly update us upon successful transaction for verification purpose.
Many thanks!

The words with red color is the particular i get from my database.
My question is can i use the data in my Access database to automatic create a message? or maybe create a button in my form, when i click a button, the Message is create automatically.

Every time sending a similar Message is waste a lot of time and there are a lot of typo error.

I look forward to get response from here

Thank you in advance.

 

[pbaldy]

Welcome to the site. You should get a good start with this:

http://granite.ab.ca/access/email.htm

 

[qiqinuinaifen128]

Thank you for your info. But don't know how to use it in my Database.

 

[stopher]

Re: Message Generate Automatically

How are you sending the SMS message? Email? Or through some SMS software?

You can certainly build up a string from data in your form. It's just a case of what you want to do with it.

Dim mySMS as String

mySMS="CONFIRMATION" & vbCrLr & "Instructor: " & [InstructorName] & " " & [InstructorID] etc

Chris

 

[pbaldy]

Reading the various links would have shown you how. Since you've chosen to start a duplicate thread, I won't bother following up here.

 

[wazz]

duplicate thread merged here.