Outlook Data Question
Author
Discussion

Carsie

Original Poster:

937 posts

223 months

Wednesday 10th February 2010
quotequote all
Please could any of you clever IT chaps help me with an Outlook question?

I have a batch of email messages that have "bounced" and I want to view them in Excel so that I can update them. Sorting them in Excel is not the problem it's how can I get them into a readable format into Excel thats causing the issue.

I think its how my Outlook view is configured and then I can copy paste/export but it's currently stumping me.

Thanks in advance chaps

Munter

31,330 posts

260 months

Wednesday 10th February 2010
quotequote all
When you go to file is there an Import Export option. Follow that through and Export to an Excel file? You'll get the whole folder you select to export. So you could put the e-mails into a folder in outlook and export that.

Or did you try that already and I've got wrong end of stick again. smile

Carsie

Original Poster:

937 posts

223 months

Wednesday 10th February 2010
quotequote all
Hi Munter, sorry for late reply it's been a very long day phone

Thanks for the advice and you are right that's what I went for first but it just came out as unusable (poor grammar)

What I'm trying to do is to parse the e-mail data to enable me to extract the-mail address so that I can then update Client record on a different system by using Excel/CSV import.

This is one of the bounces and I'm having to wade through all this gumpf and there's more before I can find the address I've sent it to.I have changed the IP addresses.....

Hi. This is the qmail-send program at yahoo.com.
I'm afraid I wasn't able to deliver your message to the following addresses.
This is a permanent error; I've given up. Sorry it didn't work out.

<xxxxx.xxx@xxxxxx.com>:
xx.xx.xx.xx does not like recipient.
Remote host said: 550 5.1.1 <xxxx.xxx@xxxxx>: Recipient address rejected: xxxxxxng up on xx.xxx.xxx.xxx.

--- Below this line is a copy of the message.

Return-Path: <xxxxx.@xxxxxx.com>
Received: (qmail 94148 invoked from network); 7 Jan 2010 13:30:04 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
s=s1024; d=btinternet.com;
h=Received:X-Yahoo-SMTP:X-YMail-OSG:X-Yahoo-NXXXXXX-XXXXXXX:From:To:Subject:Date:Message-ID:MIME-Version:Content-Type:X-Mailer:Content-Language;
b=kSKE+82VE6r3vzdgzh/uJ/8gRBhatqIY1DcKpTGB1aXLW5O5FLiwGqWUsorDcBD8fXnV
From: "Michael Carr" <xxxxxxxx@xxx.com>
To: "Mr John Doe" <xxxxxxxxx@xxxxxx.com>
Subject: xxxxxxx
Date: Thu, 7 Jan 2010 13:29:58 -0000


Finally I know this is the result of old data but this is the only section of data that I have to work with. Like a good Irishman "I know I shouldn't be wanting to be starting from here now" laugh

Any ideas?