Need Help for a Formula

[CeBit]

Hello all,

I need help to generate a email list.

Here is an example.

I want to start the list at : [email protected]

I want to finish the list at: [email protected]

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

 

[Alan]

www.rondebruin.nl/
I'm sure you will find what you need here, Ron really is the main man on
this topic,
Regards,
Alan

 

[duane]

if you have '[email protected] in cell a5, this creates next entry in cel
a6 (up to '[email protected])

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

 

[Frank Kabel]

Hi
see your post in Excel.misc

 

[anonymous]

-----Original Message-----
if you have '[email protected] in cell a5, this creates next entry in cell
a6 (up to '[email protected])

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

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

Copy down as needed.