I have a list of email addresses in column A and I am using this to create a 'To' list for the email;
GDL = Join(Application.Transpose(Sheet1.Range("A1:A1000").Value), ";")
What I'd really like to do though is hide each email address from the others by sending them as Bcc - can it be done?