How to send Outlook Meeting VIA PHP Mailer with Excel Attachment?

[FooKelvin]

Hi Guys,

 

I have a application, once the button is trigger, the php mailer will send outlook meeting to participant and block their calendar.

 

Like This:

 

My question is, how can i attach excel spreadsheet in this calendar?

This is the expected result from user end:

 

 

As you can see there is a excel spreadsheet attached in the appointment email.

 

Above are my codes:

$text = "BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Microsoft Corporation//Outlook 11.0 MIMEDIR//EN
METHOD:REQUEST
BEGIN:VTIMEZONE
TZID:Singapore Standard Time
BEGIN:STANDARD
TZOFFSETFROM:+0800
TZOFFSETTO:+0800
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
UID:" . md5(uniqid(mt_rand(), true)) . "example.com
DTEND:". $date . "T" . $endTime . "00
DTSTAMP:" . gmdate('Ymd') . 'T' . gmdate('His') . "Z
DTSTART:". $date . "T" . $startTime . "00
SUMMARY:" . $subject . "
ORGANIZER;CN=" . $organizer . ":mailto:" . $organizer_email . "
LOCATION:" . $location . "
DESCRIPTION:" . $desc . "
TRANSP:TRANSPARENT
BEGIN:VALARM
TRIGGER:-PT30M
ACTION:DISPLAY
DESCRIPTION:Reminder
END:VALARM
END:VEVENT
END:VCALENDAR";

I have tested this line of code:

ATTACH;ENCODING=BASE64;VALUE=BINARYXFILENAME=iq.xlsx:?????  //<-- Not sure what to code here.

But i cant get what i want.

 

Please Help.