|
|
|
|
|
|
|
|
|
|
|
|
|
|
OUTLOOKPOWER ANSWER TEAM
Storing data and data files in your email system
By Francine Otterson
OutlookPower reader Gary Grinnell is thinking of moving from Yahoo's free mail to either Outlook or Outlook Express so he can store files in his email. We're not sure email's the best solution for what he's trying to do, but we'll do our best to help!
Here's what he told us:
I get an email every workday that has the date as part of the heading and consists of a table of commodity names on the left and a set of price parameters reading across the top.
I would like to store the files in email. The key is to be able to extract and reformat the information and copy it into Excel 97. Can I do this if I get the email in Outlook or Outlook Express (cheaper is better).
Currently I am in Yahoo email and there seems to no way to do the above-I think I should switch to some form of Outlook. I can't get anywhere trying to deal with Yahoo.
Thanks for your help and advice. I can write simple macros in Excel.
The best method for sharing documents, both sending and receiving, is to send it as an attachment. This will allow the recipient to save the actual attachment as a file on their system and associate it with the appropriate program.
If the information is typed or pasted into the actual email, then it is actually part of the email itself and is associated with that particular email program.
Just as our reader Gary is experiencing, this limits the options for saving or editing the information. And to be able to do anything with the information, it would have to be copied and pasted into the program you need to use and then possibly reformatted.
The best approach for functionality and productivity is to request the originator to send the information as an attachment. This will allow the recipient to then save the attachment in Outlook by going to File->Save Attachment. There are a lot of other Outlook-related features you'll then be able to use as well.
There's also a non-Outlook option you might want to consider, and that's Gmail. Google offers a very large data store (2GB at last look) where you can store your messages. You might consider creating a new Gmail account just for your files, and send your messages into the Gmail account. There are some third-party hacks that will let you access your Gmail email messages just as if they were files, so you might then be able to get the information access you desire.
It sounds like you're looking for more of a database application though, rather than email. Think through the architecture of the application and implement something that's both reliable and simple.
Submit your questions to the OutlookPower Answer Team Submit your Outlook questions to editor@outlookpower.com with the words "OUTLOOKPOWER ANSWER TEAM" in the subject line. Francine Otterson, President of the San Diego Outlook User Group, and its members, make up the OutlookPower Answer Team and are always available to answer your tough Outlook questions.
For more information on the San Diego Outlook User Group, visit http://groups.yahoo.com/group/sdoutlookug.
Product availability and resources For more information on Gmail, visit http://www.gmail.com.
|
Francine Otterson is the President of the San Diego Outlook User Group and a Microsoft Outlook MVP. She has been in the IT industry for over 10 years, providing technical support, software customization solutions and training in corporate settings, and as a consultant. She balances her work around her daughter and husband in sunny San Diego, California.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-- Advertisement --
Write for OutlookPower today!
Share your experience and expertise with other Outlook and Exchange users, administrators, and developers. OutlookPower Magazine has grown nicely and now has new opportunities for contributing authors and editors.
Write about something you're an expert on and get your name in lights.
For Writers' Guidelines and to discuss topics, contact Staff Editor Steve Niles. This is your opportunity to shine in front of your peers, your clients, and other readers.
Click for more info! |
-- Advertisement --
Sent Items Organizer
When you need to file your sent email into their proper folders based on keywords or who it's to. It's also perfect for shared mailboxes.
It also adds a "Send And File" toolbar button while you're composing (similar to the way Lotus Notes used to work) for quick and easy filing.
Find out more! |
|
|
|
|
|
The Power Magazine for Microsoft Outlook and Exchange Users at OutlookPower.com
Copyright © 1998-2010, ZATZ Publishing. All rights reserved worldwide. Outlook is a trademark of Microsoft Corporation.
|
|
|
|
|
|
|