can I copy a column of email addresses, paste into email address?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I too have a list of email addresses in one column and would like to insert
all addresses into one email for a mass mailing, is it possible to do without
copy and pasting each email address in one at a time?
 
I'd use this.

Insert a new column to the right of the email address column.

I'm gonna use A for my email column and B for my new column.

Put this in B1:
=A1
put this in B2:
=B1&";"&A2
(Change the separator to what you need)

And drag down the column.

Copy that last cell and paste into your email to: field.
 
Or just paste into Word. Highlgiht the table in Word, go to Table -> Convert
->
Table to Text, having it use whatever separator (comma or semicolon, etc.).
It will create a nice list easily copied into the email.
 
I tried it but when I copy and paste the column that was converted into text
it still wouldn't paste all of the addresses, it would only paste the first
one in the line.
 
When you copy that last cell you must then PasteSpecial, Values intoi another cell. Only copy and paste that cell into your email: field.
 
Back
Top