Outlook to excel

Scripting Forums AppleScript | Mac OS X
,
#1

My attempts to copy the body of outlook email to an excel document result in truncation of the content.
Is there limitation to the number of characters that this function is capable of?

Model: Mac
Browser: Chrome
Operating System: Mac OS X (10.8)

#2

Welcome to MacScripter!

This works for me, can you give it a try.
Select a message in Outlook first.


tell application "Microsoft Outlook"
	activate
	set thisMessage to selection
	set ptContent to plain text content of thisMessage
end tell

tell application "Microsoft Excel"
	activate
	activate object worksheet 1 of front workbook
	set value of cell ("A1") to ptContent
end tell
#3

Thank you for the assistance.
This works great for the selected message in Outlook.
How would you script it to do all of the messages in a particular inbox folder?

#4

Hi there,

Open a new workbook in Excel and then select the mail folder you want in Outlook.
Then try this…


tell application "Microsoft Excel"
	activate
	activate object worksheet 1 of front workbook
end tell

tell application "Microsoft Outlook"
	activate
	
	set thisMailFolder to selection
	set thisMailFolderCount to count of incoming messages of thisMailFolder
	
	repeat with thisItemNo from 1 to thisMailFolderCount
		
		set ptContent to plain text content of (message thisItemNo of thisMailFolder)
		
		tell application "Microsoft Excel"
			set value of cell ("A" & thisItemNo) to ptContent
		end tell
		
	end repeat
	
end tell