Solved

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

Posted on 2009-07-10
3
230 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

When you have clients or friends from around the world, it becomes a challenge to arrange a meeting or effectively manage your time. This is where Outlook's capability to show 2 time zones in one calendar comes in handy.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
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: …

688 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