Hello,

I'd need assistance writing an AppleScript to extract the first name, last name,  nickname, and sender address from every message in a folder in Outlook for mac:2011 then populate a new Excel spreadsheet. Once in Excel, I'll manually remove duplicates.

I want to rebuild my autocomplete history in Outlook for mac:2011 after migrating from Apple Mail.

Outlook only allows you to Add Sender to Address Book one message at a time.

Here's what I have:

on run {}

tell application "Microsoft Outlook"

set theAccount to imap account "Me"

-- Get the messages selected in Outlook

set currentMessages to current messages

set mailFolders to name of folders of theAccount as list

-- Check to make sure items are selected, if not then quit

if ((count of currentMessages) < 1) then return

-- Iterate through selected messages

repeat with aMessage in currentMessages

-- Get the account for the message

set messageAccount to account of aMessage

set messageSender to sender of aMessage

sender of every message of folder "INBOX" of the theAccount as list

end repeat

end tell

end run



Thank you.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.