Help- using VBA to pull appointment data from web to create oulook appointment
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3

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

Hybrid View

  1. #1
    Join Date
    May 2012
    Posts
    2

    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

  2. #2
    Join Date
    Jan 2006
    Location
    Chicago, IL
    Posts
    14,877

    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.
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

  3. #3
    Join Date
    May 2012
    Posts
    2

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

    Quote Originally Posted by dglienna View Post
    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
  •  


Azure Activities Information Page

Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center