Thank you for the tip to Extract Actual Addresses From Hyperlinks in Excel With VBA Code. It was exactly what I needed! 

This works great for me, thank you. I'm having one challenge. I'd like to insert a hyperlink into the body of the email that says something like click "here" but currently can only get it to work using the full web address inserted into the body.

@Coreen LoeppkyGood shout. I didn't realise things surrounding group schedules had changed until I read your comment. (although I should have guessed having dealt with this exact problem you described. Constant changes, many being MASSIVE inconveniences to us the workers using them and little online information about the new changes and many user guides becoming outdated incorrect information). So much time is wasted sometimes.

I have come this far but can not understand anything. I have forty blogs, about hundred pages to convert, but there is no information about how to doo full pages. Could you, or somebody, help out this old man-84 with his first computer, with some simple method how to do it!!!!????

this only works temporarily, when i try to restart the auto-complete doesn't work anymore

A problem with this approach is that it requires you to have your invitees in your people list. This is not always practical.

https://womensbeautyoffers.com/features-of-modern-foot-spa-massagers-that-increased-its-market-demand/
As technology advanced, so did our personal care tools. Just a decade or two back, personal care meant expensive spa visits on the weekends, which not only took a bit off our wallets but also made an impact on our social life as they were time-consuming.

How do I do carry out the first method using a row reference instead of a column one? - that is, replace the column reference 3 with a row reference in the formula?

Nice, Thanks!!!