+ Reply to Thread
Results 1 to 2 of 2

Incerting the Date in an Outlook meeting invite generated from Excel

  1. #1
    Forum Contributor
    Join Date
    09-22-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Office 2019
    Posts
    217

    Cool Incerting the Date in an Outlook meeting invite generated from Excel

    Hi!

    I have a spreadsheet that lists people to invite to meetings and has their organisation and contact details in it. The day and time of the meeting depends on the person.
    I've produced a code that opens an Outlook Calendar meeting invitation to send to each individual using the cell with the contact's email address in as the focal point to work from. Once the address cell is selected relevant data, (persons name, meeting day, date, time ect.) is produced in a specific block of cells in a row. The code picks up the relevant information and fills in the Outlook meeting invite.

    However, the .Date = ("d",5, Now) brings up a Compile Error. I tried directing to the cell with the day/date using .Date=[AJ2] which seems to work OK for the other commands, but this brings up an error “Object doesn’t support this object or method". The day/date in AJ2 is =TEXT(AC2,"ddddd, dd mmmm yyyy") from the date code in AC2.

    If I remove the .Date command completely the Start time that comes up is correct as is the end time (Start +30 mins) but the date comes up as “Sat 30/12/1899”

    The code is as follows:

    Please Login or Register  to view this content.
    Any ideas where I'm going wrong with this please??

    Thanks in advance

    Frankie

  2. #2
    Forum Contributor
    Join Date
    09-22-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Office 2019
    Posts
    217

    Re: Incerting the Date in an Outlook meeting invite generated from Excel

    OK. Cracked it! I've taken the ,Date out and made the cell that .Start refer to show the date and time as "dd/mm/yyyy h:mm AM/PM" and all is good!

+ 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] Outlook 2016 - VBA Macro for replying with attachment in meeting invite
    By JaCrispy in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 04-06-2018, 07:45 PM
  2. Outlook meeting invite using cell values
    By JRC1 in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 04-05-2017, 07:13 AM
  3. Send outlook invite through excel macro
    By vijanand1279 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-14-2016, 01:47 PM
  4. Accepting a meeting invite without responding
    By scott.xlsx in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2015, 05:31 PM
  5. [SOLVED] Sending invite through Outlook 2007 via excel macro or VBA
    By kartikeyadawar in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-10-2015, 06:03 AM
  6. Meeting invite via Excel
    By JimmyQ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-05-2014, 08:20 AM

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