Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 20th, 2006, 10:21 AM
Authorized User
 
Join Date: Jun 2004
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default Extract Email into Excel

I am trying to somehow extract the info. from an email msg. directly into Excel for analysis. I would appreciate if someone could advice how to connect to the Email server for Outlook and how to read a particular message.

Thanks

 
Old April 21st, 2006, 05:44 AM
Registered User
 
Join Date: Apr 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

MSG Files:

Priasoft has several MSG related products. http://www.priasoft.com

In particular, they have a MSG file parsing library that gives developers access to all the properties of a .msg file, without outlook.

They also have an export library that works with the MSG library for exporting msg files to other formats, like PDF, TIF, and HTML.

For PST files, they have a couple of command line tools that allow extraction of messages to MSG, again without requiring outlook, and it supports both ANSI and UNICODE pst files. There is also the reverse, a MSG to PST utility.

They also have a viewer product that looks very similar to outlook 2003 with regards to the User Interface. The viewer can view, search, print, and export msg files.

Lastly, they just release a free ViewOnly viewer here: http://www.priasoft.com/msgview.exe


Regards,
the MSG Guru, Eriq VanBibber

ALT160 - Do you see me?





Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Excel to Email krose Excel VBA 0 November 14th, 2007 12:42 PM
Email with Excel kalebson Excel VBA 1 January 2nd, 2007 06:02 AM
Extract Excel data to Access Database sriramus Access VBA 1 February 28th, 2006 01:52 PM
HELP !!! extract informarion from email Ivan83sg XML 0 December 8th, 2004 10:35 AM
Email Updates from Excel pstaffeld Excel VBA 1 August 20th, 2003 07:09 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.