Hi all,

Really stuck on this and would appreciate the help.

I have multiple emails I want to blind cc by clicking a single button.
They populate cells A1 through to A23 - I want A24 to be hyperlinked so that an email will open up with all previous cells in column A bcced. I understand this will look something like: =hyperlink(mailto:&bcc=X) but I have no idea what X is.

Someone please help as this function has just become business critical.

Thanks in advance,

Raymo1