Generating Email Addresses

[jpodrebarac]

OK so this is my first post so I hope I cover everything that may be pertinent.

I am wanting to create an email list of sorts. When marketing to companies I usually have an email address of a handful of people in the organization but a list a mile long of contact names at the company. Since I have a few addresses I know the standard format i.e. John Smith is jsmith@randomcompany.com or johns@randomcompany.com. Of course I can do this by hand but it becomes tedious. Is there a way to create a spreadsheet in which the first name would be in one column and last name in another with a third column with the proper email format and have excel pick up the format.

I am thinking it would be something similar to when you have a known pattern i.e. 1, 2, 3, etc that you select then grab the corner to drag down to continue the pattern.

I hope this makes sense, if not please let me know what additional information is needed.

Thanks,
JP

[jaslake]

Hi

Welcome to the Forum!

Take a look at this link... http://www.excelforum.com/excel-prog...el-2007-a.html

It utilizes the approach you described.

create a spreadsheet in which the first name would be in one column and last name in another with a third column with the proper email format and have excel pick up the format

[Mordred]

Hi jpodrebarac and welcome to the forum. First I'll display the code

Please Login or Register  to view this content.

and now I'll explain.
Starting in A1, I used an initial like "j"
B1 value = "smith"
C1 value = @address.com
B2 value = "r"
C2 value = "smith"
and so on! C1 value is the extension and is always referred to within the code I gave you. Is this close?

[Domski]

Hi,

Which format do you want for the email addresses?
Is there a possibility of duplicate names and if so how should that be dealt with?

Dom

[jpodrebarac]

Mordred, I think this is close to what I am looking to do. I need to get back up to speed with running code in Excel but I think this will work.

Domski, the format will be dependent on the base email pattern. Sometimes I may be using first initial and last name, other times it may be first name and last initial or any other various pattern. If there are duplicates i.e. John Smith and Jenny Smith I would have to deal with that on a one off basis if the typical format is first initial and last name. This said I do not think this issue will create problems all that often, I can just do a quick remove duplicates