Kein Problem, script inside…

die Excel Datei muss geöffnet sein. Dann code in Script Editor.app kopieren und starten

set addressRange to "F2:F122"
 
tell application "Microsoft Excel"
  set mailAddresses to {}
  repeat with anItem in (get value of range addressRange of active sheet)
    set end of mailAddresses to item 1 of anItem
  end repeat
end tell
 
tell application "Mail"
  set newMessage to make new outgoing message with properties {visible:true}
  repeat with anAddress in mailAddresses
    tell newMessage to make new bcc recipient at end of bcc recipients with properties {address:anAddress}
  end repeat
end tell