Hi,
I have never posted any question in any forum so please excuse me if i am missing something.
I have a query with a series of email addresses (the query is in fact a distribution list)
a@gmail.com
b@gmail.com
c@gmail.com
I want to put all of these addresses into the Outlook field of BCC. in the following format a@gmail.com; b@gmail.com; c@gmail.com
i will then write different mails different, with subjects but always to the same group.
I do not want to use the distribution list functionality of Outlook.
I have seen various complicated VBA that send always the same e-mail to different people or adds attachments, or send it to one person only. But cannot send it to multiple.
I would like to press a button on the top and send the addresses on a list to the BCC field in outlook and allow editing the email
Thanks for your support
J