VBA to open multiple mailto: hyperlinks at once

[elgato74]

Dear all

please have a look at the attached file.

I am trying to open multiple maito- hyperlinks at once, which you can find in Column "BI"

each hyperlink looks like this:

=HYPERLINK("mailto:" & E2 & "?subject=[WICHTIG] " & A2 & "&body=" &BL2; "Send email")

Ideally, the vba should ask me for the range before execution.

btw, the links work if I click them one by one.

Any help is appreciated !