Re: Outlook with perl

2008-08-18 Thread Jenda Krynicky
From:   "Pat Rice" <[EMAIL PROTECTED]>
> Hi all
> Just wondering is there any way we can talk to outlook using perl, as
> in to look at a users inbox and then do an action on that ? for
> example send a mail from a users mail.
> 
> And no before you ask, I'm not trying to write another spamming application :)
> Pat

Have a look at Win32::OLE. I believe a Google search should turn up a 
few examples of Win32::OLE and Outlook.

HTH, Jenda
= [EMAIL PROTECTED] === http://Jenda.Krynicky.cz =
When it comes to wine, women and song, wizards are allowed 
to get drunk and croon as much as they like.
-- Terry Pratchett in Sourcery


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




Re: Outlook with perl

2008-08-18 Thread Dermot
2008/8/18 Pat Rice <[EMAIL PROTECTED]>:
> Hi all
> Just wondering is there any way we can talk to outlook using perl, as
> in to look at a users inbox and then do an action on that ? for
> example send a mail from a users mail.


I get about 10 hits if I search cpan for 'Outlook'.

Perhaps one of these will do what you want.
Thanx,
Dp.

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




Outlook with perl

2008-08-18 Thread Pat Rice
Hi all
Just wondering is there any way we can talk to outlook using perl, as
in to look at a users inbox and then do an action on that ? for
example send a mail from a users mail.

And no before you ask, I'm not trying to write another spamming application :)
Pat

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




Re: outlook module

2007-11-20 Thread oryann9


Why not just create a message filter or rule or whatever Outlook calls
it (or multiple ones for various criteria)?


>
>   
I did and it I cannot get it to work.





  

Be a better pen pal. 
Text or chat with friends inside Yahoo! Mail. See how.  
http://overview.mail.yahoo.com/

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




Re: outlook module

2007-11-01 Thread oryann9


- Original Message 
From: oryann9 <[EMAIL PROTECTED]>
To: Perl List 
Sent: Thursday, November 1, 2007 1:02:35 PM
Subject: Re: outlook module

 > I am looking for some humble advice. I keep getting annoying emails
 using the mail client 'Outlook 2003 SP2.' These messages are intended  for
 another 

> person in my company with the same name as I. Not to my
 surprise, the email support group decided to give this person an email  address
 that only differs 

> by one character, I was here prior to my clone.  I
 want to parse these .msg, files look for certain keywords, if these
 keywords are found compose a reply 

> email that contains a pre-written
 message template to the original sender.



> What module will fit my needs?



>It seems to me that your network admins need to correct their faulty
>procmail routing recipes. It should not be your job to deal with this.
>Do the network admins have any idea how big a problem this is? Not  only
>for your inconvenience, but for the other person not receiving
 messages?

>Jo 


##

I have informed them, however they apparently do not care. As a  courtesy, I do 
forward these specific emails on, but want to automate this  "courtesy" process.
What module(s) do you recommended?

I am using cygwin 1.5.24 and Perl 5.8.8

------

After some CPAN browsing it looks like Mail::Outlook Module Version:  0.13 fits 
the bill, unless someone has any trade-secrets?




__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com

--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




Re: outlook module

2007-11-01 Thread oryann9
> I am looking for some humble advice. I keep getting annoying emails
 using the mail client 'Outlook 2003 SP2.' These messages are intended for
 another 

> person in my company with the same name as I. Not to my
 surprise, the email support group decided to give this person an email address
 that only differs 

> by one character, I was here prior to my clone.  I
 want to parse these .msg, files look for certain keywords, if these
 keywords are found compose a reply 

> email that contains a pre-written
 message template to the original sender.



> What module will fit my needs?



>It seems to me that your network admins need to correct their faulty
>procmail routing recipes. It should not be your job to deal with this.
>Do the network admins have any idea how big a problem this is? Not only
>for your inconvenience, but for the other person not receiving
 messages?

>Jo 


##

I have informed them, however they apparently do not care. As a courtesy, I do 
forward these specific emails on, but want to automate this "courtesy" process.
What module(s) do you recommended?

I am using cygwin 1.5.24 and Perl 5.8.8




__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com

--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




Re: outlook module

2007-11-01 Thread Tom Phoenix
On 11/1/07, oryann9 <[EMAIL PROTECTED]> wrote:


> I want to parse these .msg, files look for certain keywords, if these
> keywords are found compose a reply email that contains a pre-written
> message template to the original sender.
>
> What module will fit my needs?

There's lots of modules on CPAN. Have you looked there?

http://search.cpan.org

Cheers!

--Tom Phoenix
Stonehenge Perl Training

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




RE: outlook module

2007-11-01 Thread Jo for Groups and Lists
It seems to me that your network admins need to correct their faulty
procmail routing recipes. It should not be your job to deal with this.
Do the network admins have any idea how big a problem this is? Not only
for your inconvenience, but for the other person not receiving messages?

Jo 


--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




outlook module

2007-11-01 Thread oryann9
All, 

I am looking for some humble advice. I keep getting annoying emails using the 
mail client 'Outlook 2003 SP2.' These messages are intended for another person 
in my company with the same name as I. Not to my surprise, the email support 
group decided to give this person an email address that only differs by one 
character, I was here prior to my clone.  I want to parse these .msg, files 
look for certain keywords, if these keywords are found compose a reply email 
that contains a pre-written message template to the original sender.

What module will fit my needs?

Thank you



__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com

--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




Re: Outlook CSV Parser

2007-08-10 Thread Laxminarayan G Kamath A
On Wed, 30 May 2007 12:14:52 -0400, "Chas Owens" <[EMAIL PROTECTED]>
wrote:


...
> http://www.perl.com/pub/a/2004/06/25/profiling.html
> http://search.cpan.org/~nwclark/perl-5.8.8/utils/dprofpp.PL



> The following code seems to speed up the parsing by two orders of
> magnitude (2.214 seconds 



> found 38 fields in 10 records
> found 39 fields in 9 records
> found 40 fields in 12 records
> found



> ===code to parse test file===
> #!/usr/bin/perl
> 
> use strict;
> use warnings;
> 
> my $record = "";
> my $quotes = 0;
> my @records;
> while (defined (my $line = <>)) {
> next if $record eq "" and $line =~ /^\s*$/;
> 
> $record .= $line;
> 
> #count the number of quotes
>  



Did not I thank you for this ? Shame on me.. Thanks all the same.. your
code actually helped me several folds.. 
 * It also taught me to think of optimisation more seriously. 
 * your code did not time out my cgi :-P

Thanks a tonne!

-- 
Cheers,
Laxminarayan G Kamath A
e-mail: [EMAIL PROTECTED]
Work URL: http://deeproot.in

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




Re: Outlook CSV Parser

2007-05-31 Thread Dr.Ruud
"Mumia W." schreef:
> Laxminarayan G Kamath A:

>> http://download.deeproot.in/~kamathln/outlook-encrtypted-sample.csv
>
> Well I asked for it. :-)
>
> It's impossible to tell where one record ends and another record
> begins with that file.

Maybe not, because the rule was that it ends at newline, unless inside
quotes.

-- 
Affijn, Ruud

"Gewoon is een tijger."


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




Re: Outlook CSV Parser

2007-05-31 Thread Dr.Ruud
Laxminarayan G Kamath A:
> Ruud:

>> You forgot to supply a link to such a file. Or show a __DATA__
>> section for testing.
> 
> http://download.deeproot.in/~kamathln/outlook-encrtypted-sample.csv

OK, lets check how wellformed it is:

perl -we'
  local $/;
  $_ = <>;
  s/"[^"]*"//g;
  s/(?<=,)[^",]+(?=,)//g;
  s/^[^,"]*,+//;
  print
' outlook-encrtypted-sample.csv 


That prints:
--- 
"3snji

[EMAIL PROTECTED]
--- 

so AFAICS there is a problem somewhere at the end. 

Maybe try a zipped version? 

-- 
Affijn, Ruud

"Gewoon is een tijger."

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




Re: Outlook CSV Parser

2007-05-31 Thread Mumia W.

On 05/31/2007 02:32 AM, Laxminarayan G Kamath A wrote:


http://download.deeproot.in/~kamathln/outlook-encrtypted-sample.csv



Well I asked for it. :-)

It's impossible to tell where one record ends and another record begins 
with that file.





--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




Re: Outlook CSV Parser

2007-05-31 Thread Laxminarayan G Kamath A
On Wed, 30 May 2007 10:38:40 +0200, "Dr.Ruud" <[EMAIL PROTECTED]>
wrote:

> You forgot to supply a link to such a file. Or show a __DATA__ section
> for testing.

http://download.deeproot.in/~kamathln/outlook-encrtypted-sample.csv

-- 
Cheers,
Laxminarayan G Kamath A
e-mail: [EMAIL PROTECTED]
Work URL: http://deeproot.in

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




Re: Outlook CSV Parser

2007-05-30 Thread Chas Owens

On 5/30/07, Ken Foskey <[EMAIL PROTECTED]> wrote:
snip

CSV is a horrible format.  Far too unreliable,  we have exported CSV
from excel that imported differently into excel.

snip

Just pedantic nitpick, but CSV is an incredibly reliable format, the
problem is find programs that actually use CSV rather than a CSV-like
format.  It works out to the same thing, but it isn't CSV's fault.
For an example of a programmer using a CSV-like format where he/she
should be using the real thing look at my other post on this thread.
My code fails to handle escaped double quotes correctly.

--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




Re: Outlook CSV Parser

2007-05-30 Thread Chas Owens

On 5/30/07, Laxminarayan G Kamath A <[EMAIL PROTECTED]> wrote:
snip

Any ways of optimising it further?

snip

Premature optimization is the root of all evil.  Have you profiled the
code yet?  If not then here is some documentation that will point you
in the right direction

http://www.perl.com/pub/a/2004/06/25/profiling.html
http://search.cpan.org/~nwclark/perl-5.8.8/utils/dprofpp.PL

But while I am looking lets see what is going on.

snip

1. One line need not be one record. They may cointain multine
fields.
2. A sigh of relief but : only multi-line fields are wrapped in
double quotes.
3. commas are both inside and outside the fields. the ones in
the fileds must not be treated as "seperator" - again fields with
commans are wrapped in double quotes.

snip

The following code seems to speed up the parsing by two orders of
magnitude (2.214 seconds for the old code and 0.036 seconds for this
code on 100 records).  Also, there seems to be a bug in your original
code.  I setup a test file with a 100 records of 30 fields each and it
found

found 33 fields in 1 records
found 34 fields in 1 records
found 36 fields in 3 records
found 37 fields in 5 records
found 38 fields in 10 records
found 39 fields in 9 records
found 40 fields in 12 records
found 41 fields in 17 records
found 42 fields in 15 records
found 43 fields in 13 records
found 44 fields in 7 records
found 45 fields in 5 records
found 46 fields in 1 records
found 48 fields in 1 records

===code to generate test file===
#!/usr/bin/perl

use strict;
use warnings;

my $fields= 30;
my $fieldlen  = 30;
my @fieldtype = qw(normal quoted comma);
my $records   = shift;

for my $rec (1 .. $records) {
   for my $field (1 .. $fields) {
   my $type = $fieldtype[int rand @fieldtype];
   if ($type eq 'normal') {
   print 'n' x $fieldlen, ",";
   } elsif ($type eq 'quoted') {
   print '"';
   my $i = 0;
   until ($i < $fieldlen) {
   my $len = int rand $fieldlen;
   print 'q' x $len, "\n";
   $i += $len;
   }
   print '",';
   } elsif ($type eq 'comma') {
   print '"';
   my $i = 0;
   until ($i == $fieldlen) {
   my $len = int rand $fieldlen;
   $len = $fieldlen - $i if $i+$len > $fieldlen;
   print 'c' x ($len/2), ',', 'c' x ($len/2), "\n";
   $i += $len;
   }
   print '",';
   }
   }
   print "\n";
}

===code to parse test file===
#!/usr/bin/perl

use strict;
use warnings;

my $record = "";
my $quotes = 0;
my @records;
while (defined (my $line = <>)) {
   next if $record eq "" and $line =~ /^\s*$/;

   $record .= $line;

   #count the number of quotes
   $quotes += () = $line =~ /"/g;

   #if $quotes is even then we have a full record
   if ($quotes % 2 == 0) {
   $quotes = 0;
   chomp $record;
   my @fields;
   my $unbalanced = 0;
   for my $field (split /,/, $record) {
   my $count = $field =~ s/"//g;
   if ($count % 2) {
   if ($unbalanced) {
   $unbalanced = 0;
   $fields[-1] .= ",$field";
   next;
   }
   $unbalanced = 1;
   push @fields, $field;
   next;
   }
   if ($unbalanced) {
   $fields[-1] .= ",$field";
   } else {
   push @fields, $field;
   }
   }
   push @records, { whole => $record, fields => [EMAIL PROTECTED];
   $record = "";
   }

}

for my $rec (@records) {
   print join "|", @{$rec->{fields}},"\n===\n";
}

--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




Re: Outlook CSV Parser

2007-05-30 Thread Ken Foskey
On Wed, 2007-05-30 at 13:34 +0530, Laxminarayan G Kamath A wrote:

> What I am expecting is help with the variant of the regex I used as the
> condition for while loop. I am sure If we modify that regexp a little
> bit, then we can just use it on the record like this :
> 
> $_ = $record;
> @fields = /regexp/g;
> 
> I tried a lot of different ways but just could not get the right
> regexp :-(. 

CSV is a horrible format.  Far too unreliable,  we have exported CSV
from excel that imported differently into excel.

Is there another option,  eg connecting to Outlook via a remote
connection?

Is there another format available?

I doubt a simple regex will do it if the CSV modules do not work.

What data do you have problems with?  Without samples there is nothing
we can do.


-- 
Ken Foskey
FOSS developer


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




Re: Outlook CSV Parser

2007-05-30 Thread Mumia W.

On 05/30/2007 03:04 AM, Laxminarayan G Kamath A wrote:

[...]
I tried a lot of different ways but just could not get the right
regexp :-(. 



I reiterate what the eminent Dr. Ruud said. I need some data to play 
with before I play with the code you posted.





--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




Re: Outlook CSV Parser

2007-05-30 Thread Dr.Ruud
Laxminarayan G Kamath A schreef:

> The stubling blocks : there are several types of problems in
> Outlook's CSV ..

You forgot to supply a link to such a file. Or show a __DATA__ section
for testing.

-- 
Affijn, Ruud

"Gewoon is een tijger."


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




Re: Outlook CSV Parser

2007-05-30 Thread Laxminarayan G Kamath A
On Wed, 30 May 2007 01:26:30 -0500, "Mumia W."  wrote:


> The Perl module Text::CSV_XS would make your work much simpler, and
> it might execute a little faster.

Thank you for pointing out .. but we have already tried it!
Unfortunately, it failed to seperate the records in the right fashion.
We have also tried the several more modules from CPAN.. and they were
not able to parse the OutLook's CSV. 

If you read my mail again, you might find that I already mentioned that
we tried several modules before falling back to writing our own code.

What I am expecting is help with the variant of the regex I used as the
condition for while loop. I am sure If we modify that regexp a little
bit, then we can just use it on the record like this :

$_ = $record;
@fields = /regexp/g;

I tried a lot of different ways but just could not get the right
regexp :-(. 

-- 
Cheers,
Laxminarayan G Kamath A
e-mail: [EMAIL PROTECTED]
Work URL: http://deeproot.in

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




Re: Outlook CSV Parser

2007-05-30 Thread Mumia W.

On 05/30/2007 12:40 AM, Laxminarayan G Kamath A wrote:
Hi PERLers, 
	We here at DeepRoot Linux were trying to parse Outlook's csv so

that I can add them to ldap addressbook.. [...]


The Perl module Text::CSV_XS would make your work much simpler, and it 
might execute a little faster.






--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




Re: Outlook CSV Parser

2007-05-29 Thread Laxminarayan G Kamath A
On Wed, 30 May 2007 11:10:00 +0530, Laxminarayan G Kamath A
<[EMAIL PROTECTED]> wrote:

> The attached file is what I have
> come up to.. but it still takes more 

... Had forgotten to attach the file.. 

-- 
Cheers,
Laxminarayan G Kamath A
e-mail: [EMAIL PROTECTED]
Work URL: http://deeproot.in
#!/usr/bin/perl

my $readline, $line;
$readline = "";
$line = "";
@records = ();
@fields = ();
while () {
	$readline = $_;
	if (($line eq "") && ($readline =~ /^\s*$/)) {
		next;
	}
	
	$line = $line . $readline;
	@fields=();
	if ( $line =~ /(^[^\"]*$)|(^([^\"]*(\"[^\"]*\")[^\"]*)+$)/s ) {
		chomp($line);
		print "$line\n";
		print "---\n";
		push (@records, $line);
		$last = "";
		$_ = $line;
		while (/\B\"([^\"]*)\"\B|([^\,\"]*)/g) {
			$res = "$1$2";
			push (@fields, $res);
			if ($res ne "") {
/\B\"([^\"]*)\"\B|([^\,\"]*)/g;
			}
		}
		map({print "$_\n\n"} @fields);
		print "===\n"; 
		$line = "";
	}
	
}

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/


Outlook CSV Parser

2007-05-29 Thread Laxminarayan G Kamath A

Hi PERLers, 
We here at DeepRoot Linux were trying to parse Outlook's csv so
that I can add them to ldap addressbook.. After several futile tries
around with lots of built in packages, we decided it was up to us to
device an algorithm. As time was of importance , we wrote a "well it
works!" "character by character" parsing perl algorithm. 
Wondering about how I could make it run faster, I thought I
will give regular expressions a try. The attached file is what I have
come up to.. but it still takes more than 10 seconds on my 1.6 GHZ P4
with 1G RAM to parse a 6500+ lines of CSV . and seperate them  out ..
Let alone importing them to LDAP. Any ways of optimising it further?
The stubling blocks : there are several types of problems in
Outlook's CSV .. 
1. One line need not be one record. They may cointain multine
fields.
2. A sigh of relief but : only multi-line fields are wrapped in
double quotes.
3. commas are both inside and outside the fields. the ones in
the fileds must not be treated as "seperator" - again fields with
commans are wrapped in double quotes.
 
I hope I am on the right mailing list.. Else, please direct me to the
proper one.

-- 
Cheers,
Laxminarayan G Kamath A
e-mail: [EMAIL PROTECTED]
Work URL: http://deeproot.in

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/




RE: CSV file that can be loaded to Microsoft Outlook

2006-06-26 Thread Timothy Johnson
You have an extra double-quote in there after the email address.  So far
this doesn't seem to be a Perl problem.

-Original Message-
From: Mihir Kamdar [mailto:[EMAIL PROTECTED] 
Sent: Sunday, June 25, 2006 7:02 AM
To: Mr. Shawn H. Corey
Cc: beginners
Subject: Re: CSV file that can be loaded to Microsoft Outlook

hii,

thanx a lot for your immediate reply...

now i m able to import but after that it is not taking up correct
values.

Following is the line that i m trying to import. Now if i keep this as a
single line in the CSV file (no word wrap), then Outlook is not
importing
it. Only if I break the line, then it is taking it...but in that case
while
maping the fields, when I do next in souce file, then it wipes off all
the
previous mappings. So ultimately after importing to contacts, I m
getting
jumbled up values(like Mobile No against first name,etc)..
I have no clue as to where i m wrong.

, "Suhail", , "Khan", , "Xyz Technologies Ltd", "Engineering", "VP
-Engineering", "nth Block,  Koramangala", "Bangalore 560 095 India", , ,
, ,
, , , , , , , , , , , , , , , , , , , , , "+91-80-2500, ext 3300", ,
, ,
, "+91-99", , , , , , , , , , , , , , , , , "
[EMAIL PROTECTED]", , "suhailk", , , , , , , , , , , , , , , ,
, ,
, , "004", , , , , , , , , , , , ,

thanx,
mihir



On 6/24/06, Mr. Shawn H. Corey <[EMAIL PROTECTED]> wrote:
>
> On Sat, 2006-24-06 at 10:50 -0400, Ryan Frantz wrote:
> > 'CSV' means _Comma_ Separated Values.  Semicolons won't work.
>
> CSV are also doubly escaped. Commas in CSV are escaped by placing them
> inside double-quotes. Double-quotes, inside double-quotes, are escaped
> by placing two in a row; but if they're outside double-quotes, there's
> just one of them. The following is a valid CSV line:
>
> ,",","""","""""",""","""
>
> Confused? I recommend you find a module in CPAN to format your output
> correctly.
>
> http://search.cpan.org/
>
>
> --
> __END__
>
> Just my 0.0002 million dollars worth,
>   --- Shawn
>
> "For the things we have to learn before we can do them, we learn by
doing
> them."
> Aristotle
>
> * Perl tutorials at http://perlmonks.org/?node=Tutorials
> * A searchable perldoc is at http://perldoc.perl.org/
>
>
>
> --
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> <http://learn.perl.org/> <http://learn.perl.org/first-response>
>
>
>


--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>




Re: CSV file that can be loaded to Microsoft Outlook

2006-06-25 Thread Mihir Kamdar

hii,

thanx a lot for your immediate reply...

now i m able to import but after that it is not taking up correct values.

Following is the line that i m trying to import. Now if i keep this as a
single line in the CSV file (no word wrap), then Outlook is not importing
it. Only if I break the line, then it is taking it...but in that case while
maping the fields, when I do next in souce file, then it wipes off all the
previous mappings. So ultimately after importing to contacts, I m getting
jumbled up values(like Mobile No against first name,etc)..
I have no clue as to where i m wrong.

, "Suhail", , "Khan", , "Xyz Technologies Ltd", "Engineering", "VP
-Engineering", "nth Block,  Koramangala", "Bangalore 560 095 India", , , , ,
, , , , , , , , , , , , , , , , , , , , , "+91-80-2500, ext 3300", , , ,
, "+91-99", , , , , , , , , , , , , , , , , "
[EMAIL PROTECTED]", , "suhailk", , , , , , , , , , , , , , , , , ,
, , "004", , , , , , , , , , , , ,

thanx,
mihir



On 6/24/06, Mr. Shawn H. Corey <[EMAIL PROTECTED]> wrote:


On Sat, 2006-24-06 at 10:50 -0400, Ryan Frantz wrote:
> 'CSV' means _Comma_ Separated Values.  Semicolons won't work.

CSV are also doubly escaped. Commas in CSV are escaped by placing them
inside double-quotes. Double-quotes, inside double-quotes, are escaped
by placing two in a row; but if they're outside double-quotes, there's
just one of them. The following is a valid CSV line:

,",","""","""""",""","""

Confused? I recommend you find a module in CPAN to format your output
correctly.

http://search.cpan.org/


--
__END__

Just my 0.0002 million dollars worth,
  --- Shawn

"For the things we have to learn before we can do them, we learn by doing
them."
Aristotle

* Perl tutorials at http://perlmonks.org/?node=Tutorials
* A searchable perldoc is at http://perldoc.perl.org/



--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>





RE: CSV file that can be loaded to Microsoft Outlook

2006-06-24 Thread Mr. Shawn H. Corey
On Sat, 2006-24-06 at 10:50 -0400, Ryan Frantz wrote:
> 'CSV' means _Comma_ Separated Values.  Semicolons won't work.

CSV are also doubly escaped. Commas in CSV are escaped by placing them
inside double-quotes. Double-quotes, inside double-quotes, are escaped
by placing two in a row; but if they're outside double-quotes, there's
just one of them. The following is a valid CSV line:

,",",,"",""","""

Confused? I recommend you find a module in CPAN to format your output
correctly.

http://search.cpan.org/


-- 
__END__

Just my 0.0002 million dollars worth,
   --- Shawn

"For the things we have to learn before we can do them, we learn by doing them."
  Aristotle

* Perl tutorials at http://perlmonks.org/?node=Tutorials
* A searchable perldoc is at http://perldoc.perl.org/



-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
 




RE: CSV file that can be loaded to Microsoft Outlook

2006-06-24 Thread Ryan Frantz


> -Original Message-
> From: Mihir Kamdar [mailto:[EMAIL PROTECTED]
> Sent: Saturday, June 24, 2006 10:41 AM
> To: beginners
> Subject: CSV file that can be loaded to Microsoft Outlook
> 
> hi,

Howdy,

> 
> I have written a perl script whose output is a CSV file(semicolon
> seperated)

'CSV' means _Comma_ Separated Values.  Semicolons won't work.

ry

> in keeping reference to the Outlook Address Book. But whenever I am
> importing the file to Outlook, it gives me some data error, and does
not
> get
> imported.
> 
> Can anybody help me on this??
> 
> thanx,
> mihir

--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>




CSV file that can be loaded to Microsoft Outlook

2006-06-24 Thread Mihir Kamdar

hi,

I have written a perl script whose output is a CSV file(semicolon seperated)
in keeping reference to the Outlook Address Book. But whenever I am
importing the file to Outlook, it gives me some data error, and does not get
imported.

Can anybody help me on this??

thanx,
mihir


Accessing Outlook mail via Mail::Outlook

2005-05-25 Thread jason_normandin
Greeting.

I am trying to create a script that will search a user's outlook email and move 
any messages that mtahc a certain subject to a new folder.  To accomplish this 
I found the Mail::Outlook module on CPAN that allows me to easily access the 
OLE Outlook calls via Win32::Ole.

My problem is this, the Mail::Outlook module does not have a specific method to 
move an email from one mailbox to another. I can display the email when my 
match occurs, but I cannot figure out how to move it.

Here is an example of my code that works just find to pop-up an display any 
messages in my mailbox that match :

use Mail::Outlook;
use strict;

# Open filehandle to Remedy report file
open (_TICKETS,'C:\TicketCounts\MyOpen.rep') or die "Cannot open 
C:\TicketCounts\MyOpen.rep : $!";
# Iterate through each line of the file
print "Obtaining list of open tickets from $remedyReportFile  ";
while (<_TICKETS>){
# Add ticket number to array in csv format
push @myTickets, "$1" if m/CallT(\d+)/;
}
print " Ok.\n";
# Open an Outlook OLE connection
print "Opening connection to Outlook  ";
my $outlook = new Mail::Outlook('') or die "Cannot create mail object\n";
# Change to the Support mail folder
my $folder = $outlook->folder('Inbox/Support') or die "Cannot create folder 
object\n";
# Read the 1st message
print " Ok.\n";
print "Searching messages for call ticket match  " unless defined 
$bodyMatchString;
print "Searching messages for subject containing: call ticket matches and body 
containing: $bodyMatchString ... " if defined $bodyMatchString;
my $message = $folder->first();

# Iternate all messages in the folder
while ($message) {
# Strip the call ticket number out of the subject
my $callTicketNumber=$1 if $message->Subject() =~ m/CallT(\d+) /;
# If a call ticket number was found, compare against the user's open 
call tickets
if (defined $callTicketNumber) {
if ( (grep /$callTicketNumber/, @myTickets) ) { 
$emailMatches++;
$message->Display;
}
}
}

Now, I want to change the $message->Display to a move operation. Searching the 
available OLE/COM Objects for Outlook via Microsoft's OLE/COM Viewer, I see 
that there is a  move method for the mailItem CO class:

[id(0xf034), helpcontext(0x004de8b9)]
IDispatch* Move([in] MAPIFolder* DestFldr);

I tried editing the Outlook::Mesage.pm file (that stores the message display 
call) to add a call to this OLE method. 

The 1st thing I did was to see if I could simply add a new su b to the PM file 
called moveMessage that in actually would simply display the messag the same 
way the display sub did:

sub moveMessage {
my ($self,%hash) = @_;

# pre-populate the fields, if hash
foreach my $field (@autosubs) {
$self->{$field} = $hash{$field} if($hash{$field});
}

# we need a basic message fields
return 0unless($self->{To} && $self->{Subject} && 
$self->{Body});

# Build the message
$self->{message}->{To}  = $self->{To};
$self->{message}->{Cc}  = $self->{Cc}   if($self->{Cc});
$self->{message}->{Bcc} = $self->{Bcc}  if($self->{Bcc});
$self->{message}->{Subject} = $self->{Subject};
$self->{message}->{Body}= $self->{Body};

# Send the email
$self->{message}->Display();

return 1;
}

I thought this would be an easy 1st step, but come to find out, I am getting 
teh following error when I run this:

retrying default method at E:/Perl/site/lib/Win32/OLE/Lite.pm line 157, 
<_TICKETS> line 9.
Win32::OLE(0.1403) error 0x8002000e: "Invalid number of parameters"
in METHOD/PROPERTYGET "" at H:\outlook2.pl line 45

Now, I must confess that I am new to OLE and have limited exposure to Object 
Orientation. Can anyone point me in the right direction or show me some sample 
code that will move a message from one mailbox to another?

I have searched extensively for any existing code to do this, but all I have 
found are very limited and do not come close to accomplishing my goal.

I appreciate any help.

Thanks!
Jason

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>




RE: Controlling bottom posting in outlook

2004-04-26 Thread Bob Showalter
Price, Jason (TLR Corp) wrote:
> ... Is
> there a utility available that would allow me to bottom post only on
> messages I choose?  A right click option for bottom posting would be
> ideal - anyone know of a utility that can do this?     

Outlook-QuoteFix can be configured to only reformat when you hold down Ctrl
key while you click "Reply".

Click the "Advanced Options" button on the Outlook-QuoteFix window.

http://home.in.tum.de/~jain/software/outlook-quotefix/

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>




OT: Controlling bottom posting in outlook

2004-04-26 Thread Price, Jason (TLR Corp)
I've sensed that bottom posting is considered proper etiquette for this mailing list.  
Using Outlook, this is obviously not the default reply behavior.  I have seen a link 
to a utility that allows bottom posting in Outlook, but it replaces the default reply 
format for all messages.  Being in a corporate environment where everyone uses the 
same reply format, I do not want to use bottom posting for corporate communication (it 
would confuse many people around here, lol).  Is there a utility available that would 
allow me to bottom post only on messages I choose?  A right click option for bottom 
posting would be ideal - anyone know of a utility that can do this?

Thanks.

Jason

--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>




RE: How to parse Microsoft Outlook Inbox

2004-01-09 Thread Bradley A. Brown
You can also export emails into .txt files as well... At least you can on
2000 and XP. You can also get an add-on for Outlook that will automatically
do this for you. Since the one I use is a commercial program I will just say
do a google search on automatically saving emails in outlook and you should
get something.
Hope this is of use.
Bradley

-Original Message-
From: Bill Akins [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 09, 2004 12:23 PM
To: [EMAIL PROTECTED]; 'Wiggins d'Anconia'
Cc: 'PerlDiscuss - Perl Newsgroups and mailing lists'; [EMAIL PROTECTED]
Subject: RE: How to parse Microsoft Outlook Inbox


> -Original Message-
> From: Tassilo von Parseval 
> [mailto:[EMAIL PROTECTED] 
> Sent: Friday, January 09, 2004 12:24 AM
> To: Wiggins d'Anconia
> Cc: PerlDiscuss - Perl Newsgroups and mailing lists; 
> [EMAIL PROTECTED]
> Subject: Re: How to parse Microsoft Outlook Inbox
> 
> 
> On Thu, Jan 08, 2004 at 10:37:02PM -0500 Wiggins d'Anconia wrote:
> > PerlDiscuss - Perl Newsgroups and mailing lists wrote:
> > >Hi,
> > >I am trying to write a script that will parse 
> Microsoft outlook 
> > >Inbox to a .txt file.  Please let me know if there a way 
> to do that.  
> > >Thanks in advance for your help.
> > >
> > >
> > 
> > I know very little about this specific subject, but 
> Mail::Box has some
> > support for Outlook (maybe only express) mail, via 
> Mail::Transport::Dbx. 
> >  It is read only which sounds like it should support your 
> purposes, and 
> > works on dbx files whatever those are.  Other than that I 
> haven't seen 
> > any outlook mail parsers before...
> 
> In the hope that the OP was a little sloppy in his wording 
> and he did in fact mean Outlook Express then, yes, he can use 
> Mail::Transport::Dbx either directly or through Mail::Box. 
> Those dbx files are OutlookX' equivalents to the standard mbox format.
> 
> If he really meant Outlook, then he's out of luck (heh). I 
> had a look at the libpst (which is by the same authors as the 
> libdbx used in
> M::T::Dbx) but that rather put me off. Outlook's formats are 
> infinitely more complicated (there seem to be two versions of 
> those living in parallel even).
> 
> Tassilo
> -- 
> $_=q#",}])!JAPH!qq(tsuJ[{@"tnirp}3..0}_$;//::niam/s~=)]3[))_$-
> 3(rellac(=_$({
> pam{rekcahbus})(rekcah{lrePbus})(lreP{rehtonabus})!JAPH!qq(reh
> tona{tsuJbus#;
> $_=reverse,s+(?<=sub).+q#q!'"qq.\t$&."'!#+sexisexiixesixeseg;y
> ~\n~~;eval
> 
> 
Hi!
In Outlook (not sure about Express), you can export the mailbox to a
.csv or tab seperated file as well as dBase, foxpro, access, excel or a
pst file.  That may be a little step towards your goal.  Not sure what
kind of layout you are looking for in your .txt file, but that may help.


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>



--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>




RE: How to parse Microsoft Outlook Inbox

2004-01-09 Thread Bill Akins
> -Original Message-
> From: Tassilo von Parseval 
> [mailto:[EMAIL PROTECTED] 
> Sent: Friday, January 09, 2004 12:24 AM
> To: Wiggins d'Anconia
> Cc: PerlDiscuss - Perl Newsgroups and mailing lists; 
> [EMAIL PROTECTED]
> Subject: Re: How to parse Microsoft Outlook Inbox
> 
> 
> On Thu, Jan 08, 2004 at 10:37:02PM -0500 Wiggins d'Anconia wrote:
> > PerlDiscuss - Perl Newsgroups and mailing lists wrote:
> > >Hi,
> > >    I am trying to write a script that will parse 
> Microsoft outlook 
> > >Inbox to a .txt file.  Please let me know if there a way 
> to do that.  
> > >Thanks in advance for your help.
> > >
> > >
> > 
> > I know very little about this specific subject, but 
> Mail::Box has some
> > support for Outlook (maybe only express) mail, via 
> Mail::Transport::Dbx. 
> >  It is read only which sounds like it should support your 
> purposes, and 
> > works on dbx files whatever those are.  Other than that I 
> haven't seen 
> > any outlook mail parsers before...
> 
> In the hope that the OP was a little sloppy in his wording 
> and he did in fact mean Outlook Express then, yes, he can use 
> Mail::Transport::Dbx either directly or through Mail::Box. 
> Those dbx files are OutlookX' equivalents to the standard mbox format.
> 
> If he really meant Outlook, then he's out of luck (heh). I 
> had a look at the libpst (which is by the same authors as the 
> libdbx used in
> M::T::Dbx) but that rather put me off. Outlook's formats are 
> infinitely more complicated (there seem to be two versions of 
> those living in parallel even).
> 
> Tassilo
> -- 
> $_=q#",}])!JAPH!qq(tsuJ[{@"tnirp}3..0}_$;//::niam/s~=)]3[))_$-
> 3(rellac(=_$({
> pam{rekcahbus})(rekcah{lrePbus})(lreP{rehtonabus})!JAPH!qq(reh
> tona{tsuJbus#;
> $_=reverse,s+(?<=sub).+q#q!'"qq.\t$&."'!#+sexisexiixesixeseg;y
> ~\n~~;eval
> 
> 
Hi!
In Outlook (not sure about Express), you can export the mailbox to a
.csv or tab seperated file as well as dBase, foxpro, access, excel or a
pst file.  That may be a little step towards your goal.  Not sure what
kind of layout you are looking for in your .txt file, but that may help.


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>




Re: How to parse Microsoft Outlook Inbox

2004-01-08 Thread Tassilo von Parseval
On Thu, Jan 08, 2004 at 10:37:02PM -0500 Wiggins d'Anconia wrote:
> PerlDiscuss - Perl Newsgroups and mailing lists wrote:
> >Hi,
> >I am trying to write a script that will parse Microsoft outlook Inbox
> >to a .txt file.  Please let me know if there a way to do that.  Thanks in
> >advance for your help.
> >
> >
> 
> I know very little about this specific subject, but Mail::Box has some 
> support for Outlook (maybe only express) mail, via Mail::Transport::Dbx. 
>  It is read only which sounds like it should support your purposes, and 
> works on dbx files whatever those are.  Other than that I haven't seen 
> any outlook mail parsers before...

In the hope that the OP was a little sloppy in his wording and he did in
fact mean Outlook Express then, yes, he can use Mail::Transport::Dbx
either directly or through Mail::Box. Those dbx files are OutlookX'
equivalents to the standard mbox format.

If he really meant Outlook, then he's out of luck (heh). I had a look at
the libpst (which is by the same authors as the libdbx used in
M::T::Dbx) but that rather put me off. Outlook's formats are infinitely
more complicated (there seem to be two versions of those living in
parallel even).

Tassilo
-- 
$_=q#",}])!JAPH!qq(tsuJ[{@"tnirp}3..0}_$;//::niam/s~=)]3[))_$-3(rellac(=_$({
pam{rekcahbus})(rekcah{lrePbus})(lreP{rehtonabus})!JAPH!qq(rehtona{tsuJbus#;
$_=reverse,s+(?<=sub).+q#q!'"qq.\t$&."'!#+sexisexiixesixeseg;y~\n~~;eval


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>




Re: How to parse Microsoft Outlook Inbox

2004-01-08 Thread Wiggins d'Anconia
PerlDiscuss - Perl Newsgroups and mailing lists wrote:
Hi,
I am trying to write a script that will parse Microsoft outlook Inbox
to a .txt file.  Please let me know if there a way to do that.  Thanks in
advance for your help.

I know very little about this specific subject, but Mail::Box has some 
support for Outlook (maybe only express) mail, via Mail::Transport::Dbx. 
 It is read only which sounds like it should support your purposes, and 
works on dbx files whatever those are.  Other than that I haven't seen 
any outlook mail parsers before...

There also appears to be this conversion tool:

http://search.cpan.org/~dcoppit/mbx2mbox-0.34/mbx2mbox

Which once you have them in standard mbox format you can use one of the 
many mail handling modules to take it the rest of the way

Good luck,

http://danconia.org

--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>



How to parse Microsoft Outlook Inbox

2004-01-06 Thread PerlDiscuss - Perl Newsgroups and mailing lists
Hi,
I am trying to write a script that will parse Microsoft outlook Inbox
to a .txt file.  Please let me know if there a way to do that.  Thanks in
advance for your help.


Ron


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>




RE: outlook

2002-11-25 Thread John
Javeed,

You might want to take a look at:
http://www.microsoft.com/office/previous/outlook/SuprEasy.asp It should give
you a leg up on using Perl to get at the guts of Outlook -- at least it
shows a bit of an Outlook "road map".



John--
[EMAIL PROTECTED]




> -Original Message-
> From: Rob Dixon [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 25, 2002 12:34 PM
> To: [EMAIL PROTECTED]
> Subject: Re: outlook
>
>
> Javeed
>
> If Outlook is connecting to a POP3 server (rather than IMAP) then all the
> messages it has received are already on your local disk drive. I think you
> need to explain more about what you're trying to do. Do you already have a
> Perl program which processes mail? Using Perl to read email directly from
> the server is a far easier option than trying to read the Outlook files
> (whose structure is undocumented) IMO.
>
> Let us know.
>
> Rob
>
>
> - Original Message -
> From: "Javeed SAR" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, November 22, 2002 1:16 PM
> Subject: outlook
>
>
> > Hi All,
> >
> > I am working on win2000( outlook), i have a question,depending on the
> > message contents i need to do some further processing , is it
> possible to
> > automatically copy the contents of  the mail( i.e  body
> contents) to your
> > local drive or is it possible to take it in an array in PERL.
> >
> >
> > Regards
> > j
> >
>
>
>
> --
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>



-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




Re: outlook

2002-11-25 Thread Rob Dixon
Javeed

If Outlook is connecting to a POP3 server (rather than IMAP) then all the
messages it has received are already on your local disk drive. I think you
need to explain more about what you're trying to do. Do you already have a
Perl program which processes mail? Using Perl to read email directly from
the server is a far easier option than trying to read the Outlook files
(whose structure is undocumented) IMO.

Let us know.

Rob


- Original Message -
From: "Javeed SAR" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 22, 2002 1:16 PM
Subject: outlook


> Hi All,
>
> I am working on win2000( outlook), i have a question,depending on the
> message contents i need to do some further processing , is it possible to
> automatically copy the contents of  the mail( i.e  body contents) to your
> local drive or is it possible to take it in an array in PERL.
>
>
> Regards
> j
>



-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




outlook

2002-11-22 Thread Javeed SAR
Hi All,

I am working on win2000( outlook), i have a question,depending on the
message contents i need to do some further processing , is it possible to
automatically copy the contents of  the mail( i.e  body contents) to your
local drive or is it possible to take it in an array in PERL.


Regards 
j



Re: Want to know about outlook

2002-10-23 Thread Stephen Mayes
As others have pointed out outlook is purely a client connecting to, usually
exchange. For the purposes of firing off an email the only M$ option is an
exe called mapisend.exe which is a command line smtp mailer - it is part of
the back office resource kit. 

However that is charged for, personally I would use BLAT a decent, free
command line mailer and the following page is about how to use it with perl.

http://www.rrpro.com/support/webform_blat.asp
<http://www.rrpro.com/support/webform_blat.asp>  

Also whilst exchange can support LDAP, POP3, MIME etc. It will certainly
support SMTP, but one thing to watch out for is whether the server will
accept smtp connections from any IP address. Any security conscious mail
admin will lock down IP connection addresses (we do).

Hope this helps

Steve


**
This email and any attached files are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager ([EMAIL PROTECTED]).

Any misuse, transmission to unauthorised third parties or 
misrepresentation of any of the data contained in this email may
may lead to MSV Ltd seeking legal redress.

This note also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.marshallsv.com
**

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




RE: Wants to know about outlook with perl

2002-10-23 Thread Michael Hooten
You can do this from Perl if you wish. What follows is VBA code that does
almost everything you want. You will have to convert it to Win32 Perl. (Hey,
I can't do everything for you.)

What is excluded is info regarding the username and password. This info is
definitely in the Outlook VBA help file. See how to do it in Outlook VBA
then simply convert the code to Win32 Perl. I have done the same thing with
Access VBA and it is fairly simple. Please refer to the link "Using OLE with
Perl" in the ActivePerl help file. There are many examples.

---BEGIN OFFENSIVE M$ CODE HERE-
Sub SendFile()
Dim ol As Outlook.Application
Dim olMail As Outlook.MailItem

Set ol = New Outlook.Application
Set olMail = ol.CreateItem(olMailItem)

With olMail
.Recipients.Add "[EMAIL PROTECTED]"
.Subject = "My subject goes here."
.Body = "This is a test."
.Attachments.Add "E:\Documents\attachment.doc", olByValue
.Send
End With

Set ol = Nothing
Set olMail = Nothing
End Sub
END OFFENSIVE M$ CODE HERE--

-Original Message-
From: Hello Buddy [mailto:hello_buddy_001@;yahoo.com]
Sent: Tuesday, October 22, 2002 9:44 PM
To: [EMAIL PROTECTED]
Subject: Wants to know about outlook with perl


Hi,
 I am totally beginner in Perl and programming. I
have no experience before. I want to know that "is it
possible to do with perl script to write and send the
mail for outlook without opening outlook
application?".
     What I mean is I just enter user name and
password for outlook account and give the text file of
message to perl and I want perl to do it
automatically. Thanks in advance for your answers.

Best regards
Aung

__
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/



-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




RE: Wants to know about outlook with perl

2002-10-22 Thread Beau E. Cox
Oh -

If you just want to send mail, try

Mail::Sendmail v. 0.78 - Simple platform independent mailer 

on CPAN. Check out the documentation.

Sorry - I don't know anything about your other apps,
but somewhwere down deep they _must_ be using one
or more of the internet swite of mail protocols
(pop,pop3,smtp,imap, etc.).

Good luck!

Aloha => Beau.

-Original Message-
From: Hello Buddy [mailto:hello_buddy_001@;yahoo.com]
Sent: Tuesday, October 22, 2002 4:32 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Wants to know about outlook with perl


Thanks Beau,
  Just one more questions, how about other
mail application like Novell GroupWise, Lotus Notes...

  The main objective for me is doing job
automatically without launching client mail
application. Will it be possible? What CPAN modules
should I study? I am on Win32 platform. My main
objective is to send mail users according to server
mail log file. 

Best regards
Aung
--- "Beau E. Cox" <[EMAIL PROTECTED]> wrote:
> Wow -
> 
> First, I don't think you want to go to/from
> Outlook - rather you want to access the mail
> server that Outlook accesses. Check the tools->
> accounts area to see what outlook is accessing.
> 
> Next, you _can_ use perl, by way of some modules
> available on CPAN (www.cpan.org). You will most
> likely need pop3 and smtp mail components.
> 
> This is a lot easier on Unix/Linux systems rather
> than on M$ windows.
> 
> You have a steep learning curve adhead of you,
> but it should be fun.
> 
> I would suggest you get your feet wet with some
> less weighty projects to learn something about
> perl an programming in general, but, you can
> always just plunge in!
> 
> Please do some research: CPAN, how internet mail
> works (pop3/smto, etc) mail formats, etc. Jump
> into www.google.com and look!
> 
> Aloha => Beau.
> 
> -Original Message-
> From: Hello Buddy [mailto:hello_buddy_001@;yahoo.com]
> Sent: Tuesday, October 22, 2002 3:44 PM
> To: [EMAIL PROTECTED]
> Subject: Wants to know about outlook with perl
> 
> 
> Hi,
>  I am totally beginner in Perl and programming.
> I
> have no experience before. I want to know that "is
> it
> possible to do with perl script to write and send
> the
> mail for outlook without opening outlook
> application?". 
>  What I mean is I just enter user name and
> password for outlook account and give the text file
> of
> message to perl and I want perl to do it
> automatically. Thanks in advance for your answers.
> 
> Best regards
> Aung
> 
> __
> Do you Yahoo!?
> Y! Web Hosting - Let the expert host your web site
> http://webhosting.yahoo.com/
> 
> -- 
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
> 
> 
> 
> 
> -- 
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
> 


__
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/



-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




RE: Wants to know about outlook with perl

2002-10-22 Thread Timothy Johnson

Along the same lines of what Beau was saying, check your settings to see if
you are using Exchange or SMTP (Internet Mail).  If you are using Exchange,
then you can still try using the SMTP modules, many Exchange servers support
SMTP from internal clients as long as you are on the LAN.  It depends on how
much security your Network Admin has on the Exchange server.  Trying to
automate Outlook would be a lengthy and complicated task that I wouldn't
recommend for anybody.  

There is a Win32::Exchange module out there that you can use to interface
with the Exchange directory services, but I would recommend that for someone
who was a little more comfortable with Perl, and in particular the idea of
references to data structures.  To get an idea of what I mean, type these at
the command prompt:
  perldoc perlreftut
  perldoc perllol
or even better, if you're using ActiveState (which I recommend), check out
the HTML documentation and look under "Perl Core Documentation" for
perlreftut and perllol.

Anyway, check out these modules if you can swing it so that you can use
SMTP:

  Mail::Sender (good for sending attachments)
  Net::SMTP(this module is actually a good way to get a basic
understanding of how SMTP works)
  MIME::Lite
  Mail::Sendmail



-Original Message-
From: Beau E. Cox [mailto:beau@;beaucox.com]
Sent: Tuesday, October 22, 2002 7:08 PM
To: Hello Buddy; [EMAIL PROTECTED]
Subject: RE: Wants to know about outlook with perl


Wow -

First, I don't think you want to go to/from
Outlook - rather you want to access the mail
server that Outlook accesses. Check the tools->
accounts area to see what outlook is accessing.

Next, you _can_ use perl, by way of some modules
available on CPAN (www.cpan.org). You will most
likely need pop3 and smtp mail components.

This is a lot easier on Unix/Linux systems rather
than on M$ windows.

You have a steep learning curve adhead of you,
but it should be fun.

I would suggest you get your feet wet with some
less weighty projects to learn something about
perl an programming in general, but, you can
always just plunge in!

Please do some research: CPAN, how internet mail
works (pop3/smto, etc) mail formats, etc. Jump
into www.google.com and look!

Aloha => Beau.

-Original Message-
From: Hello Buddy [mailto:hello_buddy_001@;yahoo.com]
Sent: Tuesday, October 22, 2002 3:44 PM
To: [EMAIL PROTECTED]
Subject: Wants to know about outlook with perl


Hi,
 I am totally beginner in Perl and programming. I
have no experience before. I want to know that "is it
possible to do with perl script to write and send the
mail for outlook without opening outlook
application?". 
 What I mean is I just enter user name and
password for outlook account and give the text file of
message to perl and I want perl to do it
automatically. Thanks in advance for your answers.

Best regards
Aung

__
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




RE: Wants to know about outlook with perl

2002-10-22 Thread Hello Buddy
Thanks Beau,
  Just one more questions, how about other
mail application like Novell GroupWise, Lotus Notes...

  The main objective for me is doing job
automatically without launching client mail
application. Will it be possible? What CPAN modules
should I study? I am on Win32 platform. My main
objective is to send mail users according to server
mail log file. 

Best regards
Aung
--- "Beau E. Cox" <[EMAIL PROTECTED]> wrote:
> Wow -
> 
> First, I don't think you want to go to/from
> Outlook - rather you want to access the mail
> server that Outlook accesses. Check the tools->
> accounts area to see what outlook is accessing.
> 
> Next, you _can_ use perl, by way of some modules
> available on CPAN (www.cpan.org). You will most
> likely need pop3 and smtp mail components.
> 
> This is a lot easier on Unix/Linux systems rather
> than on M$ windows.
> 
> You have a steep learning curve adhead of you,
> but it should be fun.
> 
> I would suggest you get your feet wet with some
> less weighty projects to learn something about
> perl an programming in general, but, you can
> always just plunge in!
> 
> Please do some research: CPAN, how internet mail
> works (pop3/smto, etc) mail formats, etc. Jump
> into www.google.com and look!
> 
> Aloha => Beau.
> 
> -Original Message-
> From: Hello Buddy [mailto:hello_buddy_001@;yahoo.com]
> Sent: Tuesday, October 22, 2002 3:44 PM
> To: [EMAIL PROTECTED]
> Subject: Wants to know about outlook with perl
> 
> 
> Hi,
>  I am totally beginner in Perl and programming.
> I
> have no experience before. I want to know that "is
> it
> possible to do with perl script to write and send
> the
> mail for outlook without opening outlook
> application?". 
>  What I mean is I just enter user name and
> password for outlook account and give the text file
> of
> message to perl and I want perl to do it
> automatically. Thanks in advance for your answers.
> 
> Best regards
> Aung
> 
> __
> Do you Yahoo!?
> Y! Web Hosting - Let the expert host your web site
> http://webhosting.yahoo.com/
> 
> -- 
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
> 
> 
> 
> 
> -- 
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
> 


__
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




RE: Wants to know about outlook with perl

2002-10-22 Thread Beau E. Cox
Wow -

First, I don't think you want to go to/from
Outlook - rather you want to access the mail
server that Outlook accesses. Check the tools->
accounts area to see what outlook is accessing.

Next, you _can_ use perl, by way of some modules
available on CPAN (www.cpan.org). You will most
likely need pop3 and smtp mail components.

This is a lot easier on Unix/Linux systems rather
than on M$ windows.

You have a steep learning curve adhead of you,
but it should be fun.

I would suggest you get your feet wet with some
less weighty projects to learn something about
perl an programming in general, but, you can
always just plunge in!

Please do some research: CPAN, how internet mail
works (pop3/smto, etc) mail formats, etc. Jump
into www.google.com and look!

Aloha => Beau.

-Original Message-
From: Hello Buddy [mailto:hello_buddy_001@;yahoo.com]
Sent: Tuesday, October 22, 2002 3:44 PM
To: [EMAIL PROTECTED]
Subject: Wants to know about outlook with perl


Hi,
 I am totally beginner in Perl and programming. I
have no experience before. I want to know that "is it
possible to do with perl script to write and send the
mail for outlook without opening outlook
application?". 
 What I mean is I just enter user name and
password for outlook account and give the text file of
message to perl and I want perl to do it
automatically. Thanks in advance for your answers.

Best regards
Aung

__
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




Wants to know about outlook with perl

2002-10-22 Thread Hello Buddy
Hi,
 I am totally beginner in Perl and programming. I
have no experience before. I want to know that "is it
possible to do with perl script to write and send the
mail for outlook without opening outlook
application?". 
 What I mean is I just enter user name and
password for outlook account and give the text file of
message to perl and I want perl to do it
automatically. Thanks in advance for your answers.

Best regards
Aung

__
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




Re: Word and Outlook

2002-08-27 Thread Paul Tremblay

On Tue, Aug 27, 2002 at 03:50:56PM -0400, Robin Norwood wrote:
> Kirby_Sarah <[EMAIL PROTECTED]> writes:
> 
> > Hi all, 
> > 
> > I was wondering, can Perl create and format a Word document using a

I don't think there is any module to convert directly to Word. However,
there might be a module to convert text to Word RTF, which is as good
as a Word.doc. RTF is very complicated, so I don't know if anyone has
tacked this task.

Paul

> > template and can Perl create draft copies of Emails with (or without)
> > attachments?  I want to automate a report process so that perl generates the
> > reports (which I do right now into HTML format that I then save as a Word
> > document) and creates the emails so I can send them out.  I need drafts
> > because some of the emails need to have additional addresses added on
> > manually.
> > 
> > -Sarah Kirby
> > LAN Support
> > BLS
> 
> 
> The first is probably fairly difficult.  Perhaps use search.cpan.org
> to find a perl module which will output word documents.  I know
> there's one for Excel, but I've never had a reason to use one for
> Word.
> 
> For the second, you can create a template file like so:
> 
> template.txt
> '
> Dear {salutation} {first_name} {last_name},
> 
> Congratulations!  You may have already won {amount}.  That's right,
> {first_name}, the lifestyle of your dreams could be at hand!
> 
> Blah blah blah.
> '
> 
> And open it, replace the tags like so:
> 
> '
> #!/usr/bin/perl -wl
> 
> use strict;
> 
> open TEMPLATE, "template.txt"
>   or die "Could not open template.txt: $!";
> 
> local $/ = undef;
> my $temp = ;
> 
> close TEMPLATE;
> 
> my %repl = ( first_name => 'Sarah',
>last_name => 'Kirby',
>salutation => 'Ms.',
>amount => '$100,000,000'
>);
> 
> foreach my $key (keys %repl) {
>   $temp =~ s/\{$key\}/$repl{$key}/gi;
> }
> 
> print $temp;
> '
> 
> Replacing 'print $temp', with whatever e-mail code you wish to send.
> You could, for instance, loop over an array of user records, do the
> substitution for each on a copy of '$temp', and e-mail them to the
> appropriate user.
> 
> -RN
> 
> -- 
> 
> Robin Norwood
> Red Hat, Inc.
> 
> "The Sage does nothing, yet nothing remains undone."
> -Lao Tzu, Te Tao Ching
> 
> -- 
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]

-- 

*Paul Tremblay *
*[EMAIL PROTECTED]*


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




Re: Word and Outlook

2002-08-27 Thread Robin Norwood

Kirby_Sarah <[EMAIL PROTECTED]> writes:

> Hi all, 
> 
>   I was wondering, can Perl create and format a Word document using a
> template and can Perl create draft copies of Emails with (or without)
> attachments?  I want to automate a report process so that perl generates the
> reports (which I do right now into HTML format that I then save as a Word
> document) and creates the emails so I can send them out.  I need drafts
> because some of the emails need to have additional addresses added on
> manually.
> 
> -Sarah Kirby
> LAN Support
> BLS


The first is probably fairly difficult.  Perhaps use search.cpan.org
to find a perl module which will output word documents.  I know
there's one for Excel, but I've never had a reason to use one for
Word.

For the second, you can create a template file like so:

template.txt
'
Dear {salutation} {first_name} {last_name},

Congratulations!  You may have already won {amount}.  That's right,
{first_name}, the lifestyle of your dreams could be at hand!

Blah blah blah.
'

And open it, replace the tags like so:

'
#!/usr/bin/perl -wl

use strict;

open TEMPLATE, "template.txt"
  or die "Could not open template.txt: $!";

local $/ = undef;
my $temp = ;

close TEMPLATE;

my %repl = ( first_name => 'Sarah',
 last_name => 'Kirby',
 salutation => 'Ms.',
 amount => '$100,000,000'
 );

foreach my $key (keys %repl) {
  $temp =~ s/\{$key\}/$repl{$key}/gi;
}

print $temp;
'

Replacing 'print $temp', with whatever e-mail code you wish to send.
You could, for instance, loop over an array of user records, do the
substitution for each on a copy of '$temp', and e-mail them to the
appropriate user.

-RN

-- 

Robin Norwood
Red Hat, Inc.

"The Sage does nothing, yet nothing remains undone."
-Lao Tzu, Te Tao Ching

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




RE: Word and Outlook

2002-08-27 Thread Timothy Johnson


A couple of ideas:

1)  You can check CPAN to see if there is a module like
Spreadsheet::WriteExcel for Word, otherwise your best bet might be to
convert a Word Macro into Perl.  You can do this with Win32::OLE.  Check the
documentation for Win32::OLE, and you should see some examples using Excel.
After that, you can use the macro recorder to record some of the basic
things you want to do.  From there you should be able to get an idea of
where to proceed next.

2)  As for the email template, it might just be simpler to have Perl
generate an SMTP mail and send it to you, and you can add the addresses and
forward it on from there.

-Original Message-
From: Kirby_Sarah [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 11:49 AM
To: [EMAIL PROTECTED]
Subject: Word and Outlook


Hi all, 

I was wondering, can Perl create and format a Word document using a
template and can Perl create draft copies of Emails with (or without)
attachments?  I want to automate a report process so that perl generates the
reports (which I do right now into HTML format that I then save as a Word
document) and creates the emails so I can send them out.  I need drafts
because some of the emails need to have additional addresses added on
manually.

-Sarah Kirby
LAN Support
BLS


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




Word and Outlook

2002-08-27 Thread Kirby_Sarah

Hi all, 

I was wondering, can Perl create and format a Word document using a
template and can Perl create draft copies of Emails with (or without)
attachments?  I want to automate a report process so that perl generates the
reports (which I do right now into HTML format that I then save as a Word
document) and creates the emails so I can send them out.  I need drafts
because some of the emails need to have additional addresses added on
manually.

-Sarah Kirby
LAN Support
BLS


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




Help ..trying to send HTML Email to clients on outlook 2k with MIME-Lite-HTML-1.8

2002-03-27 Thread FLAHERTY, JIM-CONT

I  trying to send HTML Email to clients on outlook 2k with
MIME-Lite-HTML-1.8
I want to send reports html enabled mail intead of the old text mail .  
 
I was working with this module from CPAN , help our am I going about it the
wrong way
 
Code
 
 #!/usr/bin/perl -w
###   Get Date   ###

use strict;
use CGI qw/:standard/;
# use CGI::CARP qw/fatalsToBrowser/;
use MIME::Lite::HTML;
 
my $mailHTML = new MIME::Lite::HTML
  From   => '[EMAIL PROTECTED]'  ,
  To => '[EMAIL PROTECTED]'
 ,
#   To => param( '[EMAIL PROTECTED]'
 ),
  Subject   => 'Your html Mail';
 
url = " http://www.cnn.com <http://www.cnn.com> ";
 
 my $MIMEmail = $mailHTML->parse(param('url'));
 

  $MIMEmail->send;
 
~
~
 
errors 
 
Can't modify non-lvalue subroutine call in scalar assignment at test.cgi
line 15
, near "" http://www.cnn.com <http://www.cnn.com> ";"
Execution of test.cgi aborted due to compilation errors.

 



How to send html email from a linux box to recipents who use outlook 2k

2002-02-19 Thread FLAHERTY, JIM-CONT

  Hello , I have a perl script thats sends dept managers active adp trouble
calls to there email, is there a way I can send them in HTML format instead
of text . I use redhat 7.1 , my users use outlook 2k on win 2k 

thanks 

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




Import Appointments into Outlook using Perl and vCalendar

2002-01-08 Thread Booher Timothy B 1stLt AFRL/MNAC

Hello all,

At our lab we constantly have emails sent out in the form:

7-15 JanTesting of Product X (POC:  Joe Smith)  Room 265
2 Jan   Leaders Meeting  (POC: John Doe)Room 121
8 Jan   Review   (POC: Tom) Room 30

I am trying to take these word documents and create some time of vCalendar
file so I can automatically import all of these dates into a personal
information manager (such as Outlook or Palm). As it is everyone is
laboriously adding these things to their respective calendars or manually
inputting this information into Outlook.

Does anyone know of a module that takes inputs and generates vCalendar
files. Is there a better way to do this?

Any thoughts?

tim



Outlook Contacts

2001-12-11 Thread Akens, Anthony

Is there a Module available that will let me read in a contacts list
from an outlook .pst file, or off of an exchange server, make changes to
it, and write it back?  The area code in my state is changing, and it
would be nice to be able to script this using a regex.  Thanks in
advance for any info.


Tony

--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




RE: Extracting messages from Outlook

2001-11-21 Thread Chris Spurgeon

I've had good success using Perl to connect to a MS Outlook mail server by
using the MAIL::IMAPClient module and talking to the server via the IMAP
protocol.  The O'Reilly book "Programming Internet Email" (
http://www.oreilly.com/catalog/progintemail/ ) has a good section on this
type of thing.



Chris Spurgeon
Senior Design Technologist
[EMAIL PROTECTED]

ELECTRONIC INK
One South Broad Street
19th Floor
Philadelphia, PA 19107
www.electronicink.com

t 215.922.3800 x(233)
f 215.922.3880


-Original Message-
From: Clive Lansink [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 3:11 PM
To: [EMAIL PROTECTED]
Subject: Extracting messages from Outlook


Hi.  I would like to be able to retrieve messages using a Perl script from
an Outlook 2000 mailbox.  I am currently searching for anything to give me a
head start.  I've found something that claims to do this for Outlook Express
but on further investigation it seems this is designed to run on Unix and
attempts to directly interpret the file.  I think on a Windows system it
should be possible to do this directly through the Outlook objects.  But it
strikes me that someone may well have done this already so any suggestions
to point me in the right direction would be much appreciated.

Cheers.
CJL

Clive Lansink
Email: [EMAIL PROTECTED]
Phone: +64 9 520-4242
Fax: +64 21 789-150



-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
This e-mail is intended solely for the above-mentioned recipient and it may
contain confidential or privileged information.  If you have received it in
error, please notify us immediately and delete the e-mail.  You must not
copy, distribute, disclose or take any action in reliance on it.  In
addition, the contents of an attachment to this e-mail may contain software
viruses which could damage your own computer system.  While Electronic Ink,
Inc. and E Ink Ltd have taken every reasonable precaution to minimize this
risk, we cannot accept liability for any damage which you sustain as a
result of software viruses.  You should perform your own virus checks before
opening the attachment.

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




Re: Extracting messages from Outlook

2001-11-21 Thread Casey West

On Nov 22, 2001 at 09:11 +1300, Clive Lansink took the soap box and proclaimed:
: Hi.  I would like to be able to retrieve messages using a Perl script from
: an Outlook 2000 mailbox.  I am currently searching for anything to give me a
: head start.  I've found something that claims to do this for Outlook Express
: but on further investigation it seems this is designed to run on Unix and
: attempts to directly interpret the file.  I think on a Windows system it
: should be possible to do this directly through the Outlook objects.  But it
: strikes me that someone may well have done this already so any suggestions
: to point me in the right direction would be much appreciated.

There are a bunch of Win32::* modules to do what you want.  I've
personally not used them but I think either Win32::API or Win32::OLE
are what you want.

Read through the modules here:
  http://search.cpan.org/search?mode=module&query=Win32%3A%3A

  Casey West

-- 
"Windows NT addresses 2 Gigabytes of RAM which is more than any
application will ever need."
 -- Microsoft, 1992, on the development of Windows NT

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




Re: Extracting messages from Outlook

2001-11-21 Thread Etienne Marcotte

I don't know, but at worst, you could parse the (often REALLY huge) data
file from your mailboxes. As the unix script does. With outlook express
it's .mbx, I don't know for outlook

Etienne

Clive Lansink wrote:
> 
> Hi.  I would like to be able to retrieve messages using a Perl script from
> an Outlook 2000 mailbox.  I am currently searching for anything to give me a
> head start.  I've found something that claims to do this for Outlook Express
> but on further investigation it seems this is designed to run on Unix and
> attempts to directly interpret the file.  I think on a Windows system it
> should be possible to do this directly through the Outlook objects.  But it
> strikes me that someone may well have done this already so any suggestions
> to point me in the right direction would be much appreciated.
> 
> Cheers.
> CJL
> 
> Clive Lansink
> Email: [EMAIL PROTECTED]
> Phone: +64 9 520-4242
> Fax: +64 21 789-150
> 
> --
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]

-- 
Etienne Marcotte
Specifications Management - Quality Control
Imperial Tobacco Ltd. - Montreal (Qc) Canada
514.932.6161 x.4001

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




Extracting messages from Outlook

2001-11-21 Thread Clive Lansink

Hi.  I would like to be able to retrieve messages using a Perl script from
an Outlook 2000 mailbox.  I am currently searching for anything to give me a
head start.  I've found something that claims to do this for Outlook Express
but on further investigation it seems this is designed to run on Unix and
attempts to directly interpret the file.  I think on a Windows system it
should be possible to do this directly through the Outlook objects.  But it
strikes me that someone may well have done this already so any suggestions
to point me in the right direction would be much appreciated.

Cheers.
CJL

Clive Lansink
Email: [EMAIL PROTECTED]
Phone: +64 9 520-4242
Fax: +64 21 789-150



-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




RE: Reading an Outlook "PST" file?

2001-07-06 Thread blowther

.PST files are those written out by Macrosloth Lookout.  I'm guessing they
are streamed out COM representations.

Bruce W. Lowther

Demotivational quote for the day:
"(Don't worry if the concepts of variables and functions are not familiar;
we'll introduce these concepts as we go along.)" - Cross Platform Perl

OpenAuto Lead
Micron Technology, Inc.
Boise, Idaho
[EMAIL PROTECTED]



-Original Message-
From: Jos I. Boumans [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 06, 2001 2:45 PM
To: Wine, Michael; [EMAIL PROTECTED]
Subject: Re: Reading an Outlook "PST" file?


forgive the ignorance but what is an PST file?

on a general note: as long as it's ascii in some way or the other, there
should be no reason why perl couldnt read it
(binary would be a tad more complicated)

hth
Jos

- Original Message -
From: "Wine, Michael" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 06, 2001 9:23 PM
Subject: Reading an Outlook "PST" file?


> I need to write a script that will read an Outlook "PST" file (WIN32) so
> that I can write each mail message out to a flat file.  I have to believe
> that this is a simple thing!  Can anyone help?
>
> Thanks in Advance!
>



Re: Reading an Outlook "PST" file?

2001-07-06 Thread Luke Bakken

PST files are the native Outlook export format for Outlook folders.
Unfortunately, they are binary files, and a quick peek shows that they
might be tough to munge.  I'd suggest exporting to something more
text-friendly.


On Fri, 6 Jul 2001, Jos I. Boumans wrote:

> forgive the ignorance but what is an PST file?
>
> on a general note: as long as it's ascii in some way or the other, there
> should be no reason why perl couldnt read it
> (binary would be a tad more complicated)
>
> hth
> Jos
>
> - Original Message -
> From: "Wine, Michael" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, July 06, 2001 9:23 PM
> Subject: Reading an Outlook "PST" file?
>
>
> > I need to write a script that will read an Outlook "PST" file (WIN32) so
> > that I can write each mail message out to a flat file.  I have to believe
> > that this is a simple thing!  Can anyone help?
> >
> > Thanks in Advance!
> >
>




Re: Reading an Outlook "PST" file?

2001-07-06 Thread Jos I. Boumans

forgive the ignorance but what is an PST file?

on a general note: as long as it's ascii in some way or the other, there
should be no reason why perl couldnt read it
(binary would be a tad more complicated)

hth
Jos

- Original Message -
From: "Wine, Michael" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 06, 2001 9:23 PM
Subject: Reading an Outlook "PST" file?


> I need to write a script that will read an Outlook "PST" file (WIN32) so
> that I can write each mail message out to a flat file.  I have to believe
> that this is a simple thing!  Can anyone help?
>
> Thanks in Advance!
>




Reading an Outlook "PST" file?

2001-07-06 Thread Wine, Michael

I need to write a script that will read an Outlook "PST" file (WIN32) so
that I can write each mail message out to a flat file.  I have to believe
that this is a simple thing!  Can anyone help?

Thanks in Advance!



Re: Perl & Outlook/Exchange

2001-07-06 Thread paul


Hi Stephen,

You could attempt to write your own if you wanted.  

Have a look at IO::Socket.  You can use this to connect to the pop server.

Send "user" 
 "pass" 

Issue a STAT after logging in.  This will give you the number of messages waiting.  
The only way I can see you to work out who's messages are who's would be to issue a

   Top 1 

This returns the headers of each message.  From those you could analyse and count the 
message for each user.

Cool?

Paul.

-
"Gross, Stephan" <[EMAIL PROTECTED]>

I'd like to write a Perl application that will tell me how many messages are
sitting in an Exchange mailbox.  Implementations of both POP3 and IMAP can
query a mailbox given the username and password.  The problem is that I have
several mailboxes all using the same user account.  Outlook can do this
because it understands "profiles" - i.e., name, password *and* mailbox.  Can
someone point me to a Perl solution or Microsoft API?

___


Global WebMail -
  Delivered by Global Internet www.global.net.uk







Perl & Outlook/Exchange

2001-07-05 Thread Gross, Stephan

I'd like to write a Perl application that will tell me how many messages are
sitting in an Exchange mailbox.  Implementations of both POP3 and IMAP can
query a mailbox given the username and password.  The problem is that I have
several mailboxes all using the same user account.  Outlook can do this
because it understands "profiles" - i.e., name, password *and* mailbox.  Can
someone point me to a Perl solution or Microsoft API?

___
Stephan Gross   Loral Skynet 908-470-2388 [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> 

 



RE: Outlook Rules (was Subject Prefix)

2001-06-19 Thread John Edwards

You can set a rule in Outlook to look for [EMAIL PROTECTED] in the message
header, then move the message to a new folder.

You don't have to worry about the address being in the To: or CC: field.
Outlook will scan the whole header.

John

-Original Message-
From: Brett W. McCoy [mailto:[EMAIL PROTECTED]]
Sent: 19 June 2001 14:31
To: [EMAIL PROTECTED]
Subject: RE: Subject Prefix


On Tue, 19 Jun 2001, Pieter Heydenrych wrote:

> Actually the CC: field, which you can't create a rule for in Exchange
AFAIK.

Argh... let's not start another thread about mailers!

-- Brett
   http://www.chapelperilous.net/btfwk/

Those who have some means think that the most important thing in the
world is love.  The poor know that it is money.
-- Gerald Brenan


--Confidentiality--.
This E-mail is confidential.  It should not be read, copied, disclosed or
used by any person other than the intended recipient.  Unauthorised use,
disclosure or copying by whatever medium is strictly prohibited and may be
unlawful.  If you have received this E-mail in error please contact the
sender immediately and delete the E-mail from your system.





How to read OutLook E-Mails?

2001-04-24 Thread Helio S. Junior

Hello,


I have a WebPage here in our intranet and i would like
to know if it's possible to look for specific Outlook
e-mails when the user 'refreshes' the Page.

When one user clicks on the Refresh Button, i have to
read e-mails from a specific folder in OutLook 2000
and
update a Table inside my page.

Is it possible to do it with Perl?

Any sample code?

Thanks in Advance,


H3li0


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/