Excel - Autofill Name, Address, Phone, Fax etc.. from Outlook

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

Guest

i use Excel with office xp. i have a form we have made that requires client
Name, Address, Phone, Fax etc etc etc...

currently i keep all those contacts within my outlook contacts...

is there a way i can type in the client business name in that cell, and have
excel do one of the following:
autofill with available address, phone, fax, PC, City/Town, contact...
or...
give me a choice of available contact...

keep in mind, the Address, Phone, Fax, PC, City, Contact Name are all
different rows and colums...

Any thoughts
 
Big

One method.......

Export your Contacts from Outlook as a *.CSV file.

With your Excel workbook open, insert a new sheet.

Data>Import External Data>Import Data.

Browse to the *.CSV file and double-click to open.

Follow your nose and the Text Wizard. Your data will be comma-delimited and
go into separate cells in columns.

Use VLOOKUP function to pull this data to your form.


Gord Dibben Excel MVP
 
is there a way i can do this directly from Outlook...

if i create an excel sheet of my contacts, i have to re-create that sheet
everytime i make a change to my contacts list...

your thoughts?

thanks
 
Don't work with Outlook other than for email so can't say what easier methods
may work for you.

You could probably do it through VBA but my skills are limited.

Perhaps someone else can jump in or check out the microsoft.public.outlook
news groups.

Follow this link to all the microsoft news groups.

http://aumha.org/nntp.htm


Gord
 
Back
Top