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

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!