How do I create a simple macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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. (e-mail address removed). 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?
 
I'm not sure how you are going to 'automatically create' an email address.
If they are all in the format (e-mail address removed) 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
(e-mail address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help to create a macro 2
VBA - retrieve data on last create named range from previous inserted named range 0
Lookup+combine two spreadsheets into third 1
Create a icon. 3
macro to link worksheets 5
About excel & accesse database 1
how to move all info in column a to seperate columns 1
Lists on different sheet without using the filter. 5

Back
Top