Extracting a location from a meeting - VBA

[Joshyd]

Hi,

I am not sure if this is possible, but I have a macro that is building onboarding schedules in Word and filling in details based on an excel spreadsheet. The current problem I am having is that the locations of the meetings do change every couple of weeks. These locations are in Outlook meetings. I am wondering if there is a way for VBA to look at the meeting in the calendar (on the next onboarding day), and extract the meeting location to be inserted into the Word document.

Thanks in advance.

Josh

 

[Joshyd]

Hi There,

You were right that I did not have a solution yet! Because I know the full context of the appointments, I was able to set up a simple nested if that looks at weekdays and assigns a date based on that, but your solution seems to work too with some tweaking to fit in my sheet. I am not going to post my code because yours is way more adaptable and would be a better example for people! you are a hero @shknbk2! Thank you so much for your help

 

[shknbk2]

You're welcome.