+ Reply to Thread
Results 1 to 3 of 3

Original "start date" of postponed appointment

  1. #1
    Registered User
    Join Date
    09-16-2018
    Location
    Israel
    MS-Off Ver
    2013
    Posts
    8

    Red face Original "start date" of postponed appointment

    Hello,

    Hopefully someone could help

    I use VBA code that runs through Microsoft Outlook Appointments, and for each appointment - prints a few details - to an Excel table.

    If I set the start date of an appointment on "01-April-2019", and then postpone that appointment to "12-April-2019", and then postpone that appointment to "15-April-2019" - I have 3 "Appointment Item" objects in my folder.
    I would like to print for each appointment in the folder - the "Start Date" that was set *originally*.
    For example: Print for the first appointment - the first original start date (01-April-2019), for the first postponed appointment - the first postponed start date (12-April-2019), and for the second postponed appointment - the second postponed start date (15-April-2019).

    However, when I run my code - the *last* "Start Date" is printed (15-April-2019, 15-April-2019, 15-April-2019), instead of the original (01-April-2019, 12-April-2019, 15-April-2019) .

    I read a lot about different types of "date" objects, but couldn't find the correct one.

    Could anyone help me?

    Thank you very much!


    Please Login or Register  to view this content.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,026

    Re: Original "start date" of postponed appointment

    Cross-posted at:
    http://www.vbaexpress.com/forum/show...ed-appointment
    https://www.mrexcel.com/forum/excel-...pointment.html

    Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html
    Cheers,
    Paul Edstein
    [MS MVP - Word]

  3. #3
    Registered User
    Join Date
    09-16-2018
    Location
    Israel
    MS-Off Ver
    2013
    Posts
    8

    Re: Original "start date" of postponed appointment

    OK sorry. Won't do that again.
    Anyway could you help me figure out my problem?

+ 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