Inserting the email

  • Thread starter Thread starter Nicholas.fenning
  • Start date Start date
N

Nicholas.fenning

Hi There I have a data base of users at our company and wish to know how to
insert "@(emailaddress)" after every user in all 5000+ cells and is it
possible to import this list to outlook ?

please help

Nik

excell newbie
 
Are they all @thesame.com?

If your data is in one column, I'd insert a new column and use a formula:

=a1&"@emailaddress.com

Copy|paste special|values and toss the original column.

And if you save the file as a .csv (comma separated values), then you can
specify that inside Outlook for importing.

(I might even export the existing contacts as a .csv to see what it looks like
so I had something to match.)
 
Back
Top