If you open an calendar event in Notepad you should see something like

Just fill in the values with the data from your db and attach it with the correct file ext.
The PRODID differs depending on whether it's MS, Apple, Google etc.


BEGIN:VCALENDAR
VERSION:2.0
PRODID:
BEGIN:VEVENT
DTSTART:
DTEND:
SUMMARY:
DESCRIPTION:
END:VEVENT
END:VCALENDAR


Even though it's in plain text, its content could get really complicated if there is lots of info in the item.  It's much easier (relatively speaking) to create it with Outlook VBA (via automation from Access).  I'll post some info later.

Let's say I have three appointments: two for 8/23/24, and one for 8/24/24.  See picture below.  And I want to forward just the 12pm appointment for 8/23/24 to other people.

(To be continued.)

There is a trick involved.  Even though the Outlook ribbon lets you forward an appointment as an iCalendar file and attach it to an email automatically (see picture below), Outlook VBA doesn't let you do that.  With Outlook VBA, you have to do the two steps separately: (1) save an appointment to an .ics file, then (2) create a new email and attach the .ics file.

(To be continued.)

Below is the VBA, written in Access, that uses automation to control what is done in Outlook.  Add the Outlook object library reference as shown.  The VBA code below does the following: (1) retrieves all appointments in the default calendar, (2) filters out only the appointments in 8/23/24, and (3) create an .ics for the appointment with the title "12pm appointment".

After creating the .ics file, you can then do what Richard's email seminar has taught you and send a new email with the attachment.

Thank you Kevin and Alex!

Cool stuff. Thanks for sharing, Kevin.