+ 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
    15

    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,726

    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
    [Fmr MS MVP - Word]

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

    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)

Similar Threads

  1. Change system Date Separator to "/" and put it back to original
    By Alex Piotto in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-30-2018, 08:42 AM
  2. How to updated "yet to Start" when start date is blank
    By Sanjibghosh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-05-2018, 03:13 AM
  3. [SOLVED] VBscript to stop selection at "-----Original Message-----" plus change ";" in the output
    By 20GT in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-01-2017, 11:46 PM
  4. replace all defined range names in the sheet that start with "Street" to "Road"
    By matrex in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-04-2016, 08:53 AM
  5. Replies: 6
    Last Post: 10-04-2016, 05:01 PM
  6. [SOLVED] Force "Read Only" only in original spreadsheet - NOT in resultant "saved as" spreadsheets
    By xdrenched in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2016, 01:11 PM
  7. Replies: 11
    Last Post: 03-29-2009, 01:46 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