Gereating an email list

[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)

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

 

[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!

 

[Frank Kabel]

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