Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where can I find an excel template for creating Outlook contacts
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Excel database into Outlook Contacts says "No Named Rang | Excel Discussion (Misc queries) | |||
ODBC Excel Driver Login Failed. Could not find installable ISAM | Excel Discussion (Misc queries) | |||
Excel 2000 Cannot find Outlook 2003 | Setting up and Configuration of Excel | |||
Linking Excel to Outlook?? | Excel Discussion (Misc queries) | |||
Does anyone know where I can find a good excel template for track. | Excel Discussion (Misc queries) |