Need way to process list of emails in other program

  • Thread starter Thread starter Steve M (remove wax to reply)
  • Start date Start date
S

Steve M (remove wax to reply)

I have a list of emails (48) in one folder. I want to make a listing
of these emails and do some other work with it, either in Word or
Excel. Ideally this would have the same column headings I use now
(From, To, Subject, Sent, Size, maybe 1-2 more). I don't need the
body for this purpose, but it would be nice to have a list of
attachments (about half the emails have attachments).

I found a way to export a list to a CSV file, but it didn't give me
the Sent information, making it practically useless.

1. Is there a built-in command that will do what I need?

2. There's probably a way to write a macro, but I have not the
foggiest idea where to start.

Any help would be appreciated. Thanks.
 
add the fields you need to the view and select all, then copy. This will
give you everything you on the screen, in table format. You won't get the
attachment names. (You may need to use paste special, as text.)

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)



Search for answers: http://groups.google.com
Most recent posts to the Outlook newsgroups:
http://groups.google.com/groups?as_ugroup=microsoft.public.outlook.*&num=30
 
Diane,

Thanks for your suggestion. I finally got something like that to
work, but it is not good enough.

I already made visible the fields that I want. I then selected the
folder, then Print, Table Style. Then for the Printer, "Print to
Disk" and "Print to File".

No matter how I adjust the columns, something gets truncated; usually
some of the recipients or part of the subject. That's nonsense. I'm
not printing to a real printer, there's no reason to truncate.

BTW, I'm using Outlook 2000. Is it any better in later editions?

Steven
 
However, in your original message you said you wanted to copy the data to
Word or Excel...if you copy the data as Diane suggested and then paste it
into Excel, for example, you will get what Diane said you would get, and you
can adjust your column widths as needed to accomodate the data length (or
turn on word wrapping in the cells).

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In
 
Back
Top