Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Just get the selected mails subject into an excel file in colum A.

Posted on 2009-07-10
3
226 Views
Last Modified: 2012-05-07
Hi,

Just get the selected mails subject into an excel file in colum A.
When mails selected and run has to just get the mails subject to a file.

Regards
Sharath
0
Comment
Question by:bsharath
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
Dave Brett earned 500 total points
ID: 24830206
Shrath,

This Outlook VBA dumps all the selected mail subjects to a csv file, oAppdump.csv

Did you need anything else on this?

Cheers
Dave

Sub DumpSter()
Dim objFSO, objTF
Dim oMess As MailItem
Set objFSO = CreateObject("scripting.filesystemobject")
Set objTF = objFSO.createtextfile("C:\oAppdump.csv")
For Each oMess In ActiveExplorer.Selection
objTF.writeline oMess.Subject
Next
objTF.Close
End Sub

Open in new window

0
 
LVL 11

Author Comment

by:bsharath
ID: 24830356
Thanks Dave works perfect...
0
 
LVL 50

Expert Comment

by:Dave Brett
ID: 24830410
thx for the grade Sharath :)
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Large Outlook files lead to various unwanted errors and corruption issues. Furthermore, large outlook files can also make Outlook take longer to start-up, search, navigate, and shut-down. So, In this article, i will discuss a method to make your Out…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question