Excel to Outlook Express addresses

[headhunter]

I have a worksheet with first names and last names in two seperate columns...I would like to merge these two columns into one with a (dot) as in John.Doe and then merge a third column with the @ address listing...

Is this possible?

I would then like to import this data into an Outlook Express address book should anyone know how to do that.

Thanks

 

[Tazguy37]

A formula like this one, perhaps?:
=A1&"."&B1&"@"&C1

Where A1 is the first name, B1 the last name, and C1 contains the domain (without the @ symbol). I'll have a look at importing this into OE. Hope that helps!

 

[headhunter]

Looking good so far!!

 

[Tazguy37]

Have a look at this link for your import. I'm not sure If you need all those fields or not.

 

[headhunter]

Thanks...All set now!