Gereating an email list

C

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]

Notice that the "@mymail.net" doesnt change, just the numbers chang
only. Thats what I need generated.

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
 
D

Domenic

Hi,

A1, copied down:

=100+ROW()-ROW($A$1)&"@mymail.net"

Then select the column
Copy > Paste Special > Values
Click Ok

Hope this helps!
 
F

Frank Kabel

Hi
put the following formula in your first row:
=TEXT(ROW(100:100)&"@mymail.net")
copy down and export to Outlook
 
Top