column with emails

  • Thread starter Thread starter swirus
  • Start date Start date
S

swirus

hello,please tell me how to convert one column with email adreses to one
continuous sequence which I could put into outlook to send my message to
all people who adresses I have (its not any spam!)

Regards
S

dont use difficult to understand technical words if you can, I'm not well
in english ;)
 
Say your names are in A1:A25
Insert a new column B
in A2, type this formula:
=a1&";"&a2
Then in B3, type this formula:
=B2&";"&A3
Drag it down through B25

Check your email program to see what separator you use. (I used a semicolon.)

Then copy B25 and paste into your email program.
 
Back
Top