Adding Excel Meetings in Outlook - Missing Condition

[jdierickx]

Hi All.

I am working on setting up an Excel Scheduler where all meetings would show as Outlook Meetings.

Here is the layout of the grid:

SUBJECT LOCATION START DATE/TIME DURATION BUSY STATUS REMINDER TIME BODY ADD?
Customer A - AGM Kirchberg - Meeting Room 1 03/11/14 14:00 240 2 10080 Pls prepare meeting accordingly YES
Customer A - EGM 1 Kirchberg - Meeting Room 2 10/11/14 14:00 120 2 10080 Pls prepare meeting accordingly YES
Customer A - EGM 2 Kirchberg - Meeting Room 2 17/11/14 14:00 120 2 10080 Pls prepare meeting accordingly YES
Customer B - AGM Kirchberg - Meeting Room 2 01/12/14 14:00 360 2 10080 Pls prepare meeting accordingly YES
Customer B - EGM 1 Kirchberg - Meeting Room 3 08/12/14 14:00 120 2 10080 Pls prepare meeting accordingly YES
Customer B - EGM 2 Kirchberg - Meeting Room 3 15/12/14 14:00 120 2 10080 Pls prepare meeting accordingly YES

I found an interesting piece of VBA code for this (here below). My only issue, is that this excel grid will be a lively document ie. I will add new meetings to the existing ones. With this current code, it will duplicate the meetings every time I will run this Macro. This is an problem.
So what I would like is to add in the code a condition - This is the last column. Basically if it says "YES", it will add to Outlook. With anything else, it would do nothing.

Here is the code - Can you pls help:

Please Login or Register  to view this content.

[jdierickx]

Done ... sorry for that

[jaslake]

Hi jdierickx

Welcome to the Forum!!!

I'd suggest filtering on the last column then process only the Visible Rows.