Efficiently Managing Information Between Outlook, Excel, and Word

[Daren]

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

 

[Milly Staples [MVP - Outlook]]

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

 

[Daren]

Thanks for your reply. I'm not certain the VBA code would work because the
information is variable between the different parties that I receive from.
However, I always receive the information in Outlook. Can I extract into
Excel or Access that way? If so, what are the steps. I am using Office
2003.

Thanks again.