+ Reply to Thread
Results 1 to 11 of 11

Calendar appointments in Outlook via VBA

  1. #1
    Forum Contributor
    Join Date
    07-02-2013
    Location
    abbots langley
    MS-Off Ver
    Excel 2010
    Posts
    296

    Calendar appointments in Outlook via VBA

    HI
    I have found this wonderful piece of code, what i am looking to be able to do is add re ocurring appointments based on the number of weeks in column L. Appointment will always be the same day and time.

    Please Login or Register  to view this content.




    Thanks Michelle
    Attached Files Attached Files

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Calendar appointments in Outlook via VBA

    Just to make sure I'm looking at this correctly you're talking about recurring the number of weeks in column K?
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Calendar appointments in Outlook via VBA

    Here is a possible solutions based on the assumptions above. Book1(1).xlsm

  4. #4
    Forum Contributor
    Join Date
    07-02-2013
    Location
    abbots langley
    MS-Off Ver
    Excel 2010
    Posts
    296

    Re: Calendar appointments in Outlook via VBA

    Hi Solus

    Thanks for replying. Column K specifies the number of weeks the appointment is required for at that time. The code i have will book the first date as per column F i would like to book re-curring appointment automatically for the next 4 weeks i.e 16/12/13, 23/12/13, 30/12/13 and the 6/1/14 all for the same time and duration. I have tried to open your attachment but i receive an error message saying the file cannot be found?

    Michelle

  5. #5
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Calendar appointments in Outlook via VBA

    Lets try to upload it again Book1(1).xlsm

  6. #6
    Forum Contributor
    Join Date
    07-02-2013
    Location
    abbots langley
    MS-Off Ver
    Excel 2010
    Posts
    296

    Re: Calendar appointments in Outlook via VBA

    HI Solus,

    thansk again for responding, you kindly helped me out before i remember. I still cant activate the macro, iam receiving an error message stating that the workbook has one or more links that cant be edited, would it be because i cant access a folder you may have created in outlook?

  7. #7
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Calendar appointments in Outlook via VBA

    Perhaps you can copy and paste the code. I left the subfolder as Michelle so that shouldn't make a difference.
    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    07-02-2013
    Location
    abbots langley
    MS-Off Ver
    Excel 2010
    Posts
    296

    Re: Calendar appointments in Outlook via VBA

    Thanks Solus, Just posted it and it books the first appointment fine but not the following 4 re - ocurring?

    Michelle

  9. #9
    Forum Contributor
    Join Date
    07-02-2013
    Location
    abbots langley
    MS-Off Ver
    Excel 2010
    Posts
    296

    Re: Calendar appointments in Outlook via VBA

    Actually Solus i have just seen what its doing. The occurrance should be weekly for 4 weeks but its set it for every 4 weeks.

  10. #10
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Calendar appointments in Outlook via VBA

    Please Login or Register  to view this content.

  11. #11
    Forum Contributor
    Join Date
    07-02-2013
    Location
    abbots langley
    MS-Off Ver
    Excel 2010
    Posts
    296

    Re: Calendar appointments in Outlook via VBA

    Solus you are a genius, thanks so much for helping me out, it works perfectly.

    Michelle

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel Macro/VBA to Automate Outlook Calendar Appointments
    By LitParalegal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2012, 04:20 PM
  2. Mail merge: Converting Outlook calendar appointments into Invoices in Word
    By watfordo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-10-2011, 12:39 PM
  3. Problems with excel an calendar and outlook appointments
    By boemboem in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-09-2008, 04:42 AM
  4. Appointments from Excel into Outlook Calendar
    By Sh0t2bts in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-09-2006, 11:20 AM
  5. [SOLVED] Creating Calendar appointments
    By Andrew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2005, 08:06 PM

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