Trying to export multiple outlook appointments form excel file

I am trying to take data from an excel file an export each row into a new calendar appointment in Outlook.

I am struggling to figure out the Body of the appointment and how I can export the excel data in correctly.
When I copy a cell in column f, it will copy all of the text, when I run the macro, it only pastes the first line.
After that is pasted correctly, I want to include the hyperlinks as a reference.
Currently this is not even displaying, but if/when it does,
I want it to read: TEXT - HYPERLINK (image attached in thread)
Once the macro reaches an empty cell, I want it to drop down to the next row and repeat the process.

Thanks in advance for your help (this has been a week long endeavor, and I am at my wits end...not very talented with VBA yet).

Below is the Macro.:

Please Login or Register  to view this content.

Here are the attached images/document for a visual
PERFECT SAMPLE.JPG Incorrect Current SAMPLE.JPG Outlooktest1.xlsm

Welcome to the forum.

We'd like to help you but first..

Pls take some minutes to read forum rules and specially-in this case- rule#3 and add code tags around your code.
Then anyone will be able to help you.