email list from excel

[JChandler22]

I have a basic database of my clients set up in excel. There is one column which houses all of their email addresses.

Is there a way to quickly and easily copy all of their email addresses to paste into the BCC line of an email that I'm writing? I'd really like to avoid having to copy and paste each one individually.

Again, they're all in one single column like so:

[email protected]
[email protected]
[email protected]

and I need to copy them like so in order to put them properly into an email:

[email protected],[email protected],[email protected].

Any suggestions?

[Leith Ross]

Hello JChandler22,

Here is macro you can use on the worksheet or in your VBA code to create a comma separated list.

Please Login or Register  to view this content.

Example

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[JChandler22]

Great - a very good start. Thanks for the help.

It gets more complicated... Each contact is classified under a particular category (say category A, B, C). I have an autofilter in the 'category' column, so that I can isolate all of the people in category A, for instance. Of course, all other records are still in the table, but those rows are just hidden. As it seems, this makes your method not quite work (ie A1:A10 will select ALL of those email addresses instead of just those who are in category A).

Lastly, there are a couple instances where a client record might not include an email address, in which case I don't want a ",," (double comma with nothing in between) to appear. I think I'll probably need some sort of IF statement, but I'm not well versed enough in combining VBA and excel functions to know how to accomplish that.

Any further suggestions are greatly appreciated! Thanks again.