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