If Outlook message meets criteria then tick check-box in my db

A

ant1983

Hi,

Hope someone can help.

I developped a database for my friend's company which captures and manages
bookings. The Booking Consultant opens the form whcih takes her to a new
blank record and she then captures the booking.

The table is called tblBooking and amongst (MANY) other fields i have:

- autBookingID (Primary Key and Auto Number)
- a check box titled; PassengerSmsSent
- a check box titled; PassengerSmsDelivered

She has to manually tick this PassengerSmsSent check-box once she has
smsed/txted the client (to his mobile phone) to indicate that the message was
indeed sent. We send these sms'es via a Service Provider on the web and they
have an option where a "Delivery Report" can be sent to your email.

There is also a field where she can supply a Reference Number (on the
website).

Once this is submitted to the client AND DELIVERED she receives a standard
automated email from the service provider with the subject:

<RefNo> - <MobileNumber> - Delivered

e.g. 1285 - 27832563258 - Delivered

What i want to do:

I want my database to pick up that the message was indeed succesfully
delivered and automatically tick the PassengerSmsDelivered tick-box (so that
she doesnt have to do this)

Oh by the way; the reference number she uses (and is seen in the subject
line - 4 digits) is the autBookingID-field in tblBooking in my db.

How do i proceed? I have NO IDEA where to start.
1 - I assume this needs tons of code - Where does this code go? Outlook or
my database.
2 - Any chance someone can help me out with this code as i dont think i'll
be able to do it.
3 - Would i, if code is needed, also have to create a macro on her machine
so that it proccesses the message?
4 - If so, any chance you can stear me in the right direction regarding this?

Many thanks!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top