Contacts from excel to Outlook or vise c

K

Kess

I am using Office Standard 2007. I have also purchased Access 2007 but have
not had to much luck doing anything useful with it.

Currently, so i have all contact info in 1 place, I enter my client's
contact information in a "Master Name Page" excel worksheet that I created. I
then copy it to a different excell workbook so I can use it for estimating,
proposal and billing. I enter 1n 1 contact at a time not multiples at once. I
am a very slow typer. I am willing to enter the info into Outlook 1st, but it
doesn't quickly go into excel that I can see.

My question is this.

How can I enter contact info only 1 time and in the most time efficient
manner, use it in excel and outlook?

Would Outlook Business Contact Manager do this? Do I already have what I
need? Is it impossible?
 
L

Luther

I am using Office Standard 2007. I have also purchased Access 2007 but have
not had to much luck doing anything useful with it.

Currently, so i have all contact info in 1 place, I enter my client's
contact information in a "Master Name Page" excel worksheet that I created.. I
then copy it to a different excell workbook so I can use it for estimating,
proposal and billing. I enter 1n 1 contact at a time not multiples at once.. I
am a very slow typer. I am willing to enter the info into Outlook 1st, butit
doesn't quickly go into excel that I can see.

My question is this.

How can I enter contact info only 1 time and in the most time efficient
manner, use it in excel and outlook?

Would Outlook Business Contact Manager do this? Do I already have what I
need? Is it impossible?

You can connect an Excel spreadsheet to the BCM database. There are
two views in the BCM database, PublicAccountsView and
PublicContactsViews, that are intended for use from Microsoft Office
Accounting, Access and Excel. If your speadsheet is displaying the
contents of those views, then the spreadsheet will display the
contacts entered in BCM.
 

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

Top