Change this code to create one email with all the addresses found

Hello dcgrove,

Who is the email going to, i.e. what cell or variable holds that address? What column are the BCC address in and in which cell do they start?

Sincerely,
Leith Ross

the email needs to go to the adresses in cells b1:b3000. The code above opens an email message for each address. Ideally I would like to be able to type the subject in cell e1 and the body in cell e2, click a button and it have excel send one message with all of the addresses in the bcc field.



Thanks!
Clayton!

Hello Clayton,

Who will be the main recipient of the email? You need a "To" field if you want to send the "BCC"s.

Sincerely,
Leith Ross

I am not sure who hat will have to be. If you could just put single quotes around that line, I will find out.

Thanks!
Clayton Grove

Hello Clayton,

Here is the macro to send an email with BCCs. You will need to change the "To'" field.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

In an Internet full of geniuses you are the real deal! Thanks!


Clayton