Re: Efficiently Managing Information Between Outlook, Excel, and Word
- From: "Milly Staples [MVP - Outlook]" <what@ever>
- Date: Sun, 5 Oct 2008 17:00:00 -0700
Without knowing the type of information you need to track and report on,
there are many methods for doing this.
If the information is always in the same format, a little VBA code could do
to extract the information, put it in the format/program of your choice and
the take the action that you want.
You may also be able to extract/export the information to Access where you
can manipulate it as you wish.
Also, if you respond to this message, PLEASE include your version of Office.
--
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
How to ask a question: http://support.microsoft.com/KB/555375
After furious head scratching, Daren asked:
| Hello,
|
| I receive information from a person by e-mail in Outlook. In the
| e-mail, there can be three different pieces of information...A, B,
| and C. I have to search for each A, B, and C in Excel, and then copy
| the information I find in a table in Word and communicate this
| information in an attached word document in an e-mail to a different
| organization. The Word document also serves for me to track the flow
| of information, i.e. from whom it comes and to whom it goes. This
| process is very time consuming, so I am looking for a faster way to
| manage the information flow using this system (perhaps macros) or
| even better, to manage the information (like using another MS Office
| Product) or some kind of tracking tool. Are there any ways to
| improve the efficiency of my current system?
|
| Thanks
.
- Follow-Ups:
- References:
- Prev by Date: Re: Trying to make the jump to Outlook
- Next by Date: Re: How do I type Australia in a drop down list of countries?
- Previous by thread: Efficiently Managing Information Between Outlook, Excel, and Word
- Next by thread: Re: Efficiently Managing Information Between Outlook, Excel, and W
- Index(es):
Relevant Pages
|
