Solved

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

Posted on 2009-07-10
3
227 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
[X]
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
  • 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

733 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