How do I create a simple macro

M

Mrskydiver

I have an excel spreadsheet that has contact info. The first name in one
column i.e. Paul and the last name in another column i.e. Butler and need to
create another column that automatically creates a email address for each
name i.e. [email protected]. Then I want to import the excel contact
data into Outlook to create a contact list. I'm having a heck of a time.
Can someone help me?
 
N

Nick Hodge

I'm not sure how you are going to 'automatically create' an email address.
If they are all in the format [email protected] and you have
the company name then you could concatenate the cells (A1,B1,C1 for
simplicity of example)

=A1&"."&B1&"@"&C1&".com"

You can then save this file and go to Outlook and select File>Import/Export
and follow the wizard

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top