Help with adding Outlook Appointments from Excel - VBA

[Mikee85]

Hi,

I'm currently at a stand still (as a novice) could someone please help!!

I currently use a Macro to find data in my Excel Workbook and send an email if it requires attention today. This works fine, but i would like to add the information to my Outlook calendar as an appointment instead. Example of information;

Title = Column D (Description)
Location = Blank
All day event = True
Category = Yellow
Body = Column A
Space
Column C
Column D
Space
Column H
Column I
Column J
Space
Column L
Save & Close
I've attached a sample file that i use with the current Marco. If someone could assist me, it would be greatly appreciated.

thank you in advance

 

[Chihiro]

Here. Try adapting code in the link to your needs.
https://blogs.msdn.microsoft.com/br...cheduling-appointments-in-outlook-from-excel/

If you have issue during implementation. Ask here.

 

[Mikee85]

Hi, Thank you for your response.

This link is the one i used previously but with no avail. I just cant seem to change it from email to calendar. any help would be greatly appreciated.

Kind regards

 

[Mikee85]

I think i have found my issue. I didn't have it as a Reference in Tools>Reference>MSOutlook Object Library.

There is only one thing i can't seem to work out. When the above file sends out emails, it would put spaces between the data, where i put <BR> but in calendar it doesn't. I tried to replace it with vbNewLine_ which doesn't seem to work either. can you assist me please?

Thank you in advance

Mike