Help- using VBA to pull appointment data from web to create oulook appointment

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register or Login
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Help- using VBA to pull appointment data from web to create oulook appointment

Hello!

I'm completely new to vb and I was hoping for some help with a challenging project. First, let me explain what I'm trying to do:

I work with clients over the phone. We use proprietary web-based software to manage our clients and schedule /track appointments with them. Whenever we schedule an appointment, outlook automatically sends the client an email confirming the appointment, and I'm BCC'd on it. The problem is that the appointments dont have alerts or reminders of any kind for the account managers, so it's easy to overlook them unless you go into outlook and schedule a calendar reminder.

What I want is to integrate those appointments into outlook automatically using VB code, so that when I schedule an appointment using our software, it automatically populates in my outlook calendar. I have an idea of how the process would work:

I schedule an appointment using web software >> I receive automated email with appointment confirmation which trips an outlook rule to run Macro >> Macro pulls appointment data from specific fields on webpage that lists my appointments, then uses that data to create outlook calendar appointment.

Then, you would have to parse the email. Better idea would be to EXPORT the data, either one at a time, or in weekly batches. Easy to send the reminder emails that way.

Hmm.. I thought of that. Parsing the email will not work because the email does not reference the time zone of the client. Therefore, the "2:00pm" I extract from the email would be in the clients time, and the resulting calendar reminder that I get would be incorrect unless the client was in my time zone.