View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Where can I find an excel template for creating Outlook contacts

Should be easy enough to build from scratch.

Export your existing Contacts to a CSV file using the FileExport.

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

On Tue, 25 Jul 2006 13:42:02 -0700, Jc777
wrote:

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.