02-25-2008
|
#10 (permalink)
|
|
|
Re: Reading Outlook Messages
For calling the close method a method needs () behind it, hence the errors
(method info ) you get. Quote:
>I tried using the .Close method, which results in no changes at all, except
>for my screen being spammed
Greetings /\/\o\/\/
"Jacob Saaby Nielsen" wrote: Quote:
> Hey Shay,
>
> one more thing: When I quit Outlook, I get a million (or rather, I'm probably
> getting
> precisely 247, but I haven't stuck it out and counted - just pressed cancel
>  ),
> dialogues if I want to save the changes. Which is proably the messages I
> opened
> with the script.
>
> Best Regards,
> Jacob Saaby Nielsen
>
> http://www.pipforhelvede.net
> gmail: jacob DOT saaby
> hotmail (IM/LinkedIN/Facebook): same as gmail
> Quote:
> > I just wanted to check if you get the correct number of messages, the
> > sender
> > email address is not important.
> > Anyway, do you get the same message "cannot read..." when you manually
> > try
> > to read the messages in Outlook?
> > -----
> > Shay Levi
> > $cript Fanatic
> > http://scriptolog.blogspot.com Quote:
> >> Hey Shay,
> >>
> >> problem is - all mails sent to me, are from "Systemadministrator". So
> >> I would
> >> get nowhere from doing that.
> >> The e-mail address I need to extract is listed in the body of the
> >> e-mail.
> >> Anyway - only property I can even remotely relate to the sender,
> >> would
> >> be the userproperties property.
> >> Or is there some other property I should go for ?
> >>
> >> Best Regards,
> >> Jacob Saaby Nielsen
> >> http://www.pipforhelvede.net
> >> gmail: jacob DOT saaby
> >> hotmail (IM/LinkedIN/Facebook): same as gmail
> >>> Can you try to list email senders only (don't process the body) ?
> >>> How many do you get?
> >>>
> >>> -----
> >>> Shay Levi
> >>> $cript Fanatic
> >>> http://scriptolog.blogspot.com
> >>>> Hey guys,
> >>>>
> >>>> I'm doing this script, and as such it works ok. However, the script
> >>>> is
> >>>> counting
> >>>> 766 mails that match the subject filter,
> >>>> and I'm only getting 247 e-mail addresses from the script.
> >>>> So I poked around a bit, and noticed that a lot of the e-mail
> >>>> messages
> >>>> has
> >>>> a "This item cannot be displayed in the reading
> >>>> pane". Seems when I run the script, Outlook reaches a point where I
> >>>> have
> >>>> too many open messages at the same time.
> >>>> Anybody got a take on how to get around this ?
> >>>> I'm pasting my sourcecode so you have the option of commenting my
> >>>> code, what
> >>>> to improve, or specifically how to get
> >>>> around this "problem".
> >>>> #
> >>>> ===================================================================
> >>>> =
> >>>> =
> >>>> =
> >>>> ==========================================
> >>>> #
> >>>> # Script Information
> >>>> #
> >>>> # Title: NDRs.ps1
> >>>> # Author: Jacob Saaby Nielsen ()
> >>>> # Originally created: 06-02-2008 - 11:25:18
> >>>> # Description: Extracts e-mail addresses and error-codes from NDR
> >>>> mails,
> >>>> from a folder in Outlook
> >>>> #
> >>>> #
> >>>> ===================================================================
> >>>> =
> >>>> =
> >>>> =
> >>>> ==========================================
> >>>> #-------- Configurable Settings --------
> >>>> # $subjectFilter needs to contain the word/words of the subject you
> >>>> want
> >>>> to match
> >>>> $subjectFilter = "User Forum"
> >>>> # $NDRFolderName is the name of the folder in which you store the
> >>>> NDRs. Folder
> >>>> needs to be at the folderlevel just beneath Inbox
> >>>> $NDRFolderName = "Undelivered"
> >>>> # $NDRResultsFolder is the folder in which you want your results
> >>>> file
> >>>> located.
> >>>> End with a backslash.
> >>>> $NDRResultsFolder = "c:\"
> >>>> # $NDRResultsFile is the name of the results file
> >>>> $NDRResultsFile = "ndr-list.csv"
> >>>> #-------- Non-configurable Settings - Do not change anything after
> >>>> this line --------
> >>>> # Instantiating Outlook etc.
> >>>> $olFolderInbox = 6;
> >>>> $outlook = New-Object -com outlook.application;
> >>>> $ns = $outlook.GetNameSpace("MAPI");
> >>>> $NDRs =
> >>>> $ns.GetDefaultFolder($olFolderInbox).Folders.Item("$NDRFolderName")
> >>>> CLS
> >>>> Write-Host 'Getting total number of eAlert mails...'
> >>>> # Filter out all the files that are not meeting your subject filter
> >>>> $eAlertMails = $NDRs.Items | where {$_.Subject -match
> >>>> $subjectFilter}
> >>>> # Returns e-mail address from the message body, based on a regular
> >>>> expression
> >>>> function get-Email([string]$MailBody)
> >>>> {
> >>>> $Regex = [regex]
> >>>> "([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a
> >>>> -
> >>>> z
> >>>> A
> >>>> -Z0-9\-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})"
> >>>> $Match = $Regex.Match($MailBody)
> >>>> return $Match.Value
> >>>> }
> >>>> [int]$MailCounter = 1
> >>>> foreach ($eAlertMail in $eAlertMails.Items)
> >>>> {
> >>>> # Create and update the progress bar
> >>>> $status = "Processing mail {0} of {1}" -f $MailCounter,
> >>>> $eAlertMails.Count
> >>>> Write-Progress $status -PercentComplete ((100 / $eAlertMails.Count)
> >>>> *
> >>>> $MailCounter
> >>>> ) -Activity "Processing e-mails" -ID 1
> >>>> # Add the string to the results file
> >>>> Add-Content -path $NDRResultsFolder$NDRResultsFile -value
> >>>> (get-Email
> >>>> $eAlertMail.Body)
> >>>> # Increment $MailCounter
> >>>> $MailCounter++
> >>>> }
> >>>> Best Regards,
> >>>> Jacob Saaby Nielsen
> >>>> http://www.pipforhelvede.net
> >>>> gmail: jacob DOT saaby
> >>>> hotmail (IM/LinkedIN/Facebook): same as gmail >
>
> |
My System Specs | |