If opening the editor and jogging the code as explained higher than might be an inconvenience in your case when you need to send emails in bulk, you can to some degree carry out automation by connecting your VBA macro to your command send button. Consider new visuals – https://bookmarkstime.com/story17254487/about-send-bulk-emails