R
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
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