Solved Need Excel macro to creat email address out of just a name

December 13, 2011 at 14:18:52
Specs: Windows 7
Hi - I have a list of names for a particular company where I have the first name and last name of the customer plus the email naming convention their company uses. For example the company's email naming convention is:

Is there a way I can create an Excel Macro that will automatically create the email from the available information? For example if I create three columns where one has the first name, last name and the

I hope someone can help with this as it will save a lot of time!!

Thank You!

See More: Need Excel macro to creat email address out of just a name

Report •

December 13, 2011 at 15:39:11
✔ Best Answer
This can be done fairly easily, but I'm not going to offer any suggestions.

Since it appears that you do not work for this company, I can only assume that this will be for some sort of mass, unsolicited mailing.

If your project was sponsored by the company in question, they would supply you with a distribution list and you wouldn't have to build your own.

For all I know, I'm on that list of names that you have and I don't need any more unsolicited email.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

December 13, 2011 at 18:14:39
I completely understand your concern so please do not worry, you are not on my list. I did not realize I had to work for your company to get the info. I am not so maybe I misunderstood that this forum is not open for all to ask questions? Finally, yes this will be for sending out a mass email - however it will not be to private or personal emails - just work emails and while not the most efficient and effective way to do business, it does work sometimes and such is the nature of business development (trust me this is not the fun part for me either). This being said, I actually figured out how to do it (formula = (A1&A2) etc and I just include specific parts of email in each column so it all comes together in the end! This being said, thanks anyway for taking the time to respond and I wish you a happy holidays!

Report •

Related Solutions

Ask Question