VBA - Create Outlook Meeting based on Data

[calinini]

Hello -

I'm trying to set up a Macro (or open to ideas) to auto create an outlook reminder from excel. The issue I'm running into is that it is a shared workbook and each row has different information.

A

B

C

D

E

F

G

H

I

J

K

L

M

N​

O​

1

Date Notified

PSID

Employee Name

Job Title

MA

Work Location

HR Representative

Scenario (1-7)

PAL/WFH Begin Date

PAL/WFH End Date

RTW Follow Up Date

Best Phone Number

Employee Provided Y/N

TIME

Titlename

2

1/7/2021​

Danny

1​

1/8/2021​

1/22/2021​

1/19/2021​

(888) 888-8888​

Y

8am

Follow-Up with Danny - RTW 01-23-21

3

1/9/2021​

JoAnn

3​

1/10/2021​

1/24/2021​

1/21/2021​

(888) 888-8889​

Y

8am

Follow-Up with JoAnn - RTW 01-25-21

O =CONCATENATE("Follow-Up with ",C2," - RTW ",(TEXT(J2+1,"mm-dd-yy")))

I'd like to be able to have the user click on the Titlename and then that create an outlook reminder based on the information in that row.

For Row 1 the Reminder would be set for 8am (COL N) on 1/19/2021 (COL K) at (888) 888-8888 (COL L) with a Subject of "Follow-Up with Danny - RTW 01-23-21" (COL O).

Your help is greatly appreciated.