[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2009-07-10
3
Medium Priority
?
234 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 2000 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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

This article describes how to import Lotus Notes Contacts into Outlook 2016, 2013, 2010 and 2007 etc. with a few manual steps. You can easily export and migrate Lotus Notes contacts into Microsoft Outlook without having to use any third party tools.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

649 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