extracting all From email addresses for On My Mac Mail

hi all.

 

trying to do a final organization here after porting to mac OS.

 

i am trying to extract all emails from my archived mail in the "On My Mac" section of my mac pro. this means that this data will no longer be accessible from my laptop machine or from my iPhone when traveling. in a lot of cases there will be incoming mail from recipients whom i /may/ not have replied to or whom i did not reply to within Mac Mail (i am coming from PC land and i have used Postbaox before ditching this software awhile back).

 

i realize that i have the opportunity to ADD emails from the Previous Recipients section of my Mac Pro and from my MacBookPro - however in the case of mail that i am archiving on the Mac Pro this option is not available.

 

can anyone help me get from here to there (having some kind of list of my important email addresses) so that i can go through this list and either keep it on hand or add the important ones manually to my Contacts? i would say that alternatively i would be happy to bulk add these to the Previous Recipients list on my Mac Pro but this data is already somewhat out of hand and the fact that it resides only on my desktop until i add the addresses to Mac Contacts (as does the Previous Recipients List on my MacBook Pro and presumably on my IPhone).

 

i ran a google search and came up with the following links which i am going to print out and try and muddle through so any advice on this would be really welcome.

 

THANKS

 

extracting email addresses from On My Mac mail:

 

https://discussions.apple.com/thread/2019941?start=0&tstart=0

http://www.mac-forums.com/forums/os-x-apps-games/231559-email-address-extraction -tool.html

http://macscripter.net/viewtopic.php?id=25875

http://forums.macrumors.com/showthread.php?t=544004

http://download.cnet.com/eMail-Extractor/3000-2367_4-20864.html

View the original article here

Read More

extracting all From email addresses for On My Mac Mail

hi all.

 

trying to do a final organization here after porting to mac OS.

 

i am trying to extract all emails from my archived mail in the "On My Mac" section of my mac pro. this means that this data will no longer be accessible from my laptop machine or from my iPhone when traveling. in a lot of cases there will be incoming mail from recipients whom i /may/ not have replied to or whom i did not reply to within Mac Mail (i am coming from PC land and i have used Postbaox before ditching this software awhile back).

 

i realize that i have the opportunity to ADD emails from the Previous Recipients section of my Mac Pro and from my MacBookPro - however in the case of mail that i am archiving on the Mac Pro this option is not available.

 

can anyone help me get from here to there (having some kind of list of my important email addresses) so that i can go through this list and either keep it on hand or add the important ones manually to my Contacts? i would say that alternatively i would be happy to bulk add these to the Previous Recipients list on my Mac Pro but this data is already somewhat out of hand and the fact that it resides only on my desktop until i add the addresses to Mac Contacts (as does the Previous Recipients List on my MacBook Pro and presumably on my IPhone).

 

i ran a google search and came up with the following links which i am going to print out and try and muddle through so any advice on this would be really welcome.

 

THANKS

 

extracting email addresses from On My Mac mail:

 

https://discussions.apple.com/thread/2019941?start=0&tstart=0

http://www.mac-forums.com/forums/os-x-apps-games/231559-email-address-extraction -tool.html

http://macscripter.net/viewtopic.php?id=25875

http://forums.macrumors.com/showthread.php?t=544004

http://download.cnet.com/eMail-Extractor/3000-2367_4-20864.html

View the original article here

Read More

Extracting all email addresses contained in emails.

Canyou help me, I extracted "from" addresses with the following script:

 

--script begins

property theBoxes : {"mailbox1", "mailbox2", "mailbox3", "mailbox4", "mailbox5", "mailbox6", "mailbox7"}

 

on run

          set theMessages to {}

          tell application "Microsoft Excel"

set theSpamFile to make new workbook

set theSheet to active sheet of theSpamFile

set formula of range "B1" of theSheet to "Subject"

set formula of range "A1" of theSheet to "From"

          end tell

          tell application "Mail"

set theRow to 2

get mailboxes

--set theMessages to messages of junk mailbox

repeat with aBox in theBoxes

set theMessages to theMessages & messages of mailbox aBox

end repeat

repeat with aMessage in theMessages

my SetFrom(sender of aMessage, theRow, theSheet)

my SetSubject(subject of aMessage, theRow, theSheet)

set theRow to theRow + 1

end repeat

end tell

 

end run

 

on SetFrom(theSender, theRow, theSheet)

          tell application "Microsoft Excel"

set theRange to "A" & theRow

set formula of (range theRange) of theSheet to theSender

          end tell

end SetFrom

 

on SetSubject(theSubject, theRow, theSheet)

          tell application "Microsoft Excel"

set theRange to "B" & theRow

set formula of range theRange of theSheet to theSubject

          end tell

end SetSubject

--script ends

 

Which worked very well.

 

I now want to extract all of the to, cc and BCC emails and changed the above script to:

 

--script begins

property theBoxes : {"RWG Archive", "NRW Archive", "Contacts#Newspaper List", "JOBS R", "JOBS N"}

 

on run

          set theMessages to {}

          tell application "Microsoft Excel"

set theSpamFile to make new workbook

set theSheet to active sheet of theSpamFile

set formula of range "B1" of theSheet to "Subject"

set formula of range "A1" of theSheet to "Recipients"

          end tell

          tell application "Mail"

set theRow to 2

get mailboxes

--set theMessages to messages of junk mailbox

repeat with aBox in theBoxes

set theMessages to theMessages & messages of mailbox aBox

end repeat

repeat with aMessage in theMessages

my SetRecipients(recipients of aMessage, theRow, theSheet)

my SetSubject(subject of aMessage, theRow, theSheet)

set theRow to theRow + 1

end repeat

end tell

 

end run

 

on SetRecipients(theRecipients, theRow, theSheet)

          tell application "Microsoft Excel"

set theRange to "A" & theRow

set formula of (range theRange) of theSheet to theRecipients

          end tell

end SetRecipients

 

on SetSubject(theSubject, theRow, theSheet)

          tell application "Microsoft Excel"

set theRange to "B" & theRow

set formula of range theRange of theSheet to theSubject

          end tell

end SetSubject

--script ends

 

It does not work, I get the following error:

 

error "Can’t make «class trcp» 1 of «class mssg» id 135522 of «class mbxp» \"RWG Archive\" of application \"Mail\" into the expected type." number -1700 from «class trcp» 1 of «class mssg» id 135522 of «class mbxp» "RWG Archive"

 

I am not good at this and would appreciate help to get TO, CC and BCC address.

 

Kind Regard

 

 

o

 

 

 

o

View the original article here

Read More