See this link for emailing using VBA…
https://bobj-board.org/t/15915
BO_Chief (BOB member since 2004-06-06)