-
May 23rd, 2012, 04:32 PM
#1
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.
Any help would be greatly, greatly appreicated!!
Thanks,
Kb5K
-
May 24th, 2012, 11:13 AM
#2
Re: Help- using VBA to pull appointment data from web to create oulook 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.
-
May 24th, 2012, 11:27 AM
#3
Re: Help- using VBA to pull appointment data from web to create oulook appointment
Originally Posted by dglienna
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.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|