Outlook 2002 to Excel 2002; Smart Tags

[Ramona Goutiere]

Our office uses Excel 2002 to prepare invoices. We
presently enter the customer name and address information
by hand rather than use our Outlook Contacts database.
Although we process a small number of invoices, this
seems needlessly tedious, especially if the information
can automatically be pulled from Outlook.

Is there a way to select a customer from Outlook and have
the customer name and address information inserted
directly into a spreadsheet, much the way Microsoft Word
does for documents?

"Smart tags" may be one option. According to MS
Knowledge Base Article 289148, smart tags can be
transferred "from one Office program to another Office
program by using the Clipboard." I would like to
transfer my Microsoft Word smart tag RECOGNIZERS to Excel
in order to give them a try, but I'm not sure this can be be done. I was
able to transfer specific information with a smart tag from Word to Excel
and the smart tag worked, but can Excel be adjusted to use all the
recognizers available in Word?

Would anyone happen to know?

Any help will be sincerely appreciated.

Thanks much!

Ramona

 

[Jocelyn Fiorello [MVP - Outlook]]

You could export the contents of the Contacts folder to a .CSV file and then
import that into Excel...

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In

 

[Ramona Goutiere]

Jocelyn:

Thanks for the suggestion. What I was really hoping for was a way The Boss
could automatically insert addresses without shifting too much stuff
around--just click and go.

I may be able to automate your idea and go from there--definitely worth a
try!

Thanks for taking time to share.

Ramona