+ Reply to Thread
Results 1 to 1 of 1

Excel VBA and Outlook appointments

  1. #1
    Forum Contributor
    Join Date
    01-16-2009
    Location
    Ill.
    MS-Off Ver
    Excel 2010
    Posts
    190

    Excel VBA and Outlook appointments

    Hello VBA masters! I have some code below that pull up outlook appointments just fine. I would like to add something to the body of the appointment. I set the DIM x as a 'ticket' number and then reference that input box value in the subject line and body. This number would be found in column A of the sheet I have open. What I'd like to do is add the value from column B where x is found. I'm thinking offset(x, 1).value but I'm not sure how it 'finds' x. Suggestions? I'm thinking too I need to add to my code where is searches for the input box value in column A, but not 100% sure how that goes...Thanks..

    Please Login or Register  to view this content.
    Hello All - - I was able to find a pretty good solution that I thought I would share...below is the code I use that works for me. The date/time of the appointment is always the time I use the code, from there I change it based on everyone's availablility...works pretty good!!

    Please Login or Register  to view this content.
    Last edited by Ironman; 09-15-2011 at 09:31 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1