pop3 SSL or OUTLOOK macro?

Technical support and scripting issues

Moderators: JRL, Dorian (MJT support)

Post Reply
Snickers
Macro Veteran
Posts: 151
Joined: Thu Dec 09, 2004 3:01 pm
Location: Somewhere in TX

pop3 SSL or OUTLOOK macro?

Post by Snickers » Wed Sep 12, 2007 4:52 pm

Can RetrievePOP3 collect email from my account if the account uses SSL?

If not, does Macro Scheduler have another command that can gather email from accounts such as a Yahoo Mail Plus account?


This is what I am using right now and it is not working:

[code]
wait>3
Let>POP3_STATUS=1
Let>POP3_PORT="MY PORT NUMBER"
Let>POP3_TIMEOUT=30

RetrievePOP3>"myserver,myusername,mypassword,myoutput_path"
MessageModal>POP3_RESULT
Separate>POP3_MSGFILES,;,MsgFiles
MessageModal>Files Downloaded: %MsgFiles_count%%CRLF%File List: %POP3_MSGFILES%
[/code]

After executing the script and the script ends the STATUS window stays open and displays: "Connected"

However, nothing is downloaded into the folder my output_path points to.

EDIT: If no one is able to tell me if RetrievePOP3 is going to work, does anyone know a good site to learn how to create macros for OUTLOOK 2003?

I can check my emails using OUTLOOK 2003, now I need to have OUTLOOK store those emails as a textfile (.txt) so that Macro Scheduler can read the lines and such.

User avatar
JRL
Automation Wizard
Posts: 3529
Joined: Mon Jan 10, 2005 6:22 pm
Location: Iowa

Post by JRL » Wed Sep 12, 2007 6:40 pm

From this thread, SSL and SMTPSendMail> will not work. I doubt that POP3 and SSL will work either.

I don't know about macroing in Outlook but I have a suggestion. Have you ever considered using Pegasus Mail for your email? Using Pegasus, all new emails show up as individual text files. They are easily identifiable because they have a .CNM extension. Attachments are base64 encoded and beginning with Macro Scheduler version 9.1 there is a Base64 encode/decode function.

Just a thought,
Dick

Snickers
Macro Veteran
Posts: 151
Joined: Thu Dec 09, 2004 3:01 pm
Location: Somewhere in TX

Post by Snickers » Wed Sep 12, 2007 8:42 pm

Ok, I have installed Pegasus and the new messages are easily found. Great suggestion!

I wrote the following code to decode the .CNM file:

[code]
wait>2
GetEnvVar>USERPROFILE,profile
Let>desktop=%profile%\desktop
Input>textfile,What is the name of the file to view?

//readfile, decode, and store in variable
Readfile>%textfile%,cryptdata
Base64>cryptdata,DECODE,todecrypt
//write to textfile
WriteLn>%desktop%\Thefile.txt,r,%todecrypt%
[/code]


The textfile that it creates contains only the following text:

[code]
DECODE ERROR: SOURCE NOT BASE64
[/code]

Do you think I might be decoding incorrectly?

User avatar
JRL
Automation Wizard
Posts: 3529
Joined: Mon Jan 10, 2005 6:22 pm
Location: Iowa

Post by JRL » Wed Sep 12, 2007 9:11 pm

You are trying to decode the entire file. You need to separate out the portion of the email that is base64 coding.

This may be more difficult than I originally thought. The attachment information is apparently designated differently by differing email clients so when I look at messages that have attachments, I'm not seeing consistency in the attachment header. This will make it more difficult to determine where the attachment starts. There may be further complications when a message contains multiple attachments. I haven't looked into it enough to know for sure.

Once you acquire the attachment portion, you will also need to strip out all the carriage return line feed combos. This can easily be accomplished using the StringReplace> function.

I'll work on this tonight. Post your work if you get it to work before I do.

Later,
Dick

Snickers
Macro Veteran
Posts: 151
Joined: Thu Dec 09, 2004 3:01 pm
Location: Somewhere in TX

Post by Snickers » Wed Sep 12, 2007 9:24 pm

No no, you are right on the money. There is a feature with Pegasus that allows you to do EVERYTHING i wanted.

It will let me apply a trigger that will do the following:

If subject = "what i want it to equal"
extract body of email
create new textfile that included the body in specific folder

This means that I can use different trigger for different subject values.


You rock man. Pegasus answered a large number of my concerns.

User avatar
JRL
Automation Wizard
Posts: 3529
Joined: Mon Jan 10, 2005 6:22 pm
Location: Iowa

Post by JRL » Wed Sep 12, 2007 9:25 pm

Whew!!! Thanks for giving my evening back... :)

Post Reply
cron
Sign up to our newsletter for free automation tips, tricks & discounts