Need Help for a Formula

  • Thread starter Thread starter CeBit
  • Start date Start date
C

CeBit

Hello all,

I need help to generate a email list.

Here is an example.

I want to start the list at : (e-mail address removed)

I want to finish the list at: (e-mail address removed)

I need all the emails in a generated list. Then I could export t
outlook express and bulk email to my users.

This is for my own company and all my sales people have their emails b
numbers. So generating a automatic list would be very nice.

Thank
 
if you have '(e-mail address removed) in cell a5, this creates next entry in cel
a6 (up to '(e-mail address removed))

=CONCATENATE(LEFT(A5,3)+1,"@mymail.net"
 
-----Original Message-----
if you have '(e-mail address removed) in cell a5, this creates next entry in cell
a6 (up to '(e-mail address removed))

=CONCATENATE(LEFT(A5,3)+1,"@mymail.net")
Click to expand...

=ROW(A100)&"@mymail.net"

Copy down as needed.
 
Back
Top