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!!!

My opinion: Please think first about #2. If your friend's company needs a
coder for that he should hire someone. If you want to do the work yourself
we might be able to assist you here.

--
Best regards
Michael Bauer - MVP Outlook
Use Outlook Categories? This is Your Tool:
http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6

Am Fri, 21 Mar 2008 11:32:01 -0700 schrieb 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!!!