Where can I find an excel template for creating Outlook contacts

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

Guest

I want to add a bunch of contacts to Outlook. I thought I could create an
excel template with fields such as name, address, phone, birhtday, etc that I
could send to my contacts and ask them to fill in their information. Then, I
would import the Excel file into Outlook.
 
Should be easy enough to build from scratch.

Export your existing Contacts to a CSV file using the File>Export.

Map just the fields you are interested in. Doesn't matter if empty or not, what
you want is the headings.

Open that file in Excel and all the headings you mapped during the export will
be entered in row 1.

Save just the sheet with the headings as a workbook and ask others to fill it
in.

Note: if you map every field from Contacts you will have headings to column CN


Gord Dibben MS Excel MVP
 

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

how to generate email list for Outlook from Excel cells 4
What wrong it is about importing contact from Excel? 1
How do I move contact info from excell to Outlook? 1
Create Outlook Contact from Excel 3
Contacts from Excel to Outlook 1
Importing data from Excel worksheet into Excel template 2
importing contacts from excel to Outlook error 2
how to convert a excel database to outlook contacts 15

Back
Top