Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


Outlook to csv file in Excel

  		Logged in as: Guest
arrSession:exec spGetSession 2,2,3552
Active Users: There are 0 members and 0 guests.
Users viewing this topic: none
 

 

  
 
  Printable Version
All Forums >> [Scripting] >> WSH & Client Side VBScript >> Outlook to csv file in Excel
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks! 		Page: [1]
Login
Message << Older Topic   Newer Topic >>
Outlook to csv file in Excel - 6/27/2005 9:00:26 PM   
  BBistheKing

 

Posts: 107
Score: 0
Joined: 6/21/2005
Status: offline 		Is it possible to read set data from emails to script over to an excel (csv) spreadsheet. Example is if emails are recieved in an inbox and all the data in each email is the same standard format, but instead of actioning each individual email, can i script it over to a csv file in bulk so it can be download once all emails are scripted to the spreadsheet. The csv file can be downloaded to another system.

_____________________________

"Live simply, that others may simply live." - Mahatma Gandhi
 
 
Post #: 1
 
Re: Outlook to csv file in Excel - 6/28/2005 1:09:28 AM   
  muguk

 

Posts: 14
Score: 0
Joined: 3/17/2005
From: United Kingdom
Status: offline 		In theory, set up a rule to move all similar emails to one folder and then run the Export to CSV from the Export wizard from that folder only. That way you'll only export the information you want?

(in reply to BBistheKing)
 
 
Post #: 2
 
Re: Outlook to csv file in Excel - 7/2/2005 2:08:38 AM   
  BBistheKing

 

Posts: 107
Score: 0
Joined: 6/21/2005
Status: offline 		Wasn't quite what we were looking for as the export wizard won't do what we want (and it doesn't work on our computers at work as they are missing the necessary .fae files), but thanks any way. We need a script that will pick out specific data from several emails that are sent to a particular mailbox (so no other kinds of emails will be in this folder).

The email data will look something like this:
-----------------------------
Subject: New service MyEmail@ISP.com.au <---we need "New" and we need the email address
-----------------------------
(Body of email)
Customer Phone: 0755442233 <--number only
Speed: 256 <--number only
-----------------------------
How similar is it to extracting data from a text file? I assume this would involve using the Outlook.Application object, but I have very limited experience in vbscript and none using Outlook. I have looked at MSDN regarding Outlook but don't quite follow what I need to do.

We would be grateful for any help at all.

(in reply to BBistheKing)
 
 
Post #: 3
 
 
 
 

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [Scripting] >> WSH & Client Side VBScript >> Outlook to csv file in Excel Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts




Forum Software © ASPPlayground.NET Advanced Edition 2.5.5 ANSI