I'm trying to add a button to my current workbook that will open a new email in Lotus Notes. I almost had it but found that there is a max of 255 characters in the setup I used. I created a separate Sheet within my Workbook and named it "Contact List". The range for the list of recipients is (E2:E60). How do I write code that will open a new Lotus email with the email addresses filled in? If possible I would like to add the current Sheet as an attachment in that email. I don't want it to auto-send because I may have to add additional test within the body of the email. There will be 4-5 coworkers that will use or send this Workbook from their computer/Lotus but the recipients won't change. Thank you for your time and help.
Andrew
Bookmarks